Home » RDBMS Server » Server Utilities » sql loader issue
sql loader issue [message #69062] Tue, 23 October 2001 08:02 Go to next message
Naren
Messages: 8
Registered: October 2001
Junior Member
Hey oracle guys,
I am trying to load 107386 comma delimited records into an oracle table. The result is

34755 Rows successfully loaded.
51 Rows not loaded due to data errors.

My next step was: Use the bad file (51 rows) as the input text file and try to load the table again. The result is unsuccessful. But, if I try to load the first 50 rows in that bad file, it WORKS. That proves that there is nothing wrong with the formatting or column ordering or datatype.

Can anyone think of a reason? please lemme know.

My control file looks like this:

LOAD DATA
INFILE sxrstcr_load.txt
REPLACE INTO TABLE SXRSTCR_LOAD
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(
SXRSTCR_TERM_CODE CHAR(6),
SXRSTCR_PIDM INTEGER EXTERNAL,
SXRSTCR_CRN CHAR(5),
SXRSTCR_PTRM_CODE CONSTANT "1",
LEGACY_WCODE CHAR(1),
SXRSTCR_RSTS_DATE DATE(8) "MM/DD/YY",
SXRSTCR_ADD_DATE SYSDATE,
SXRSTCR_ACTIVITY_DATE SYSDATE,
SXRSTCR_LEVL_CODE CONSTANT "NC",
MON1_HRS FLOAT EXTERNAL NULLIF MON1_HRS = BLANKS,
MON2_HRS FLOAT EXTERNAL NULLIF MON2_HRS = BLANKS,
MON3_HRS FLOAT EXTERNAL NULLIF MON3_HRS = BLANKS,
MON4_HRS FLOAT EXTERNAL NULLIF MON4_HRS = BLANKS,
SXRSTCR_CAMP_CODE CHAR(3)
)

Example records:
"1999F",10002903,"22210",,"8/26/99",3.00,0.00,0.00,0.00,"1"
"1997W",10003187,"41689","D","1/17/97",2.00,6.00,0.00,0.00,"1"
"1995F",10003488,"20593",,"8/21/95",63.00,,,,"2"
"1998W",10003771,"42170","D","12/15/97",8.00,4.00,0.00,0.00,"9"
"1994F",10008835,"20188",,"8/29/94",,,,,"1"
"2000W",10004413,"42944",,"1/6/00",6.00,2.00,0.00,0.00,"1"

thanks in advance
naren

----------------------------------------------------------------------
Re: sql loader issue [message #69064 is a reply to message #69062] Tue, 23 October 2001 09:25 Go to previous message
touirssa
Messages: 1
Registered: October 2001
Junior Member
add erros n
-(n : number of errors to terminate the load (default=50))

----------------------------------------------------------------------
Previous Topic: SQL Loader - new line character
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Fri Mar 29 07:39:38 CDT 2024