OraFAQ Forum: Server Utilities » SQL LOADER Data file error

Home » RDBMS Server » Server Utilities » SQL LOADER Data file error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL LOADER Data file error [message #72076]

Tue, 04 March 2003 08:51

Victoria
Messages: 152
Registered: July 2002

Senior Member

Hi,
I have the input data file of varying record length of which my last column contains null.
My sample record is
TT,2/13/2003,Y,1,DN,ER,++,QQQ,C,,
RT,2/13/2003,Y,1,DN,TP,++,555,C,S2,

Here only my second record is inserted.It says the error in log file
Record 2: Rejected - Error on table TABLE1, column ACC_ID.
Column not found before end of logical record (use TRAILING NULLCOLS)

--Here the ACC_ID is the name of the last column.
What should i use in control file for this?
My control file entry is

options (direct=FALSE,parallel=false,errors=10000)
Load Data
infile 'file.dat' "str 'n'"
into table TABLE1
fields TERMINATED BY ","
(
HERE I INCLUDED my column specifications
)

Thanks
~V~

Report message to a moderator

Re: SQL LOADER Data file error [message #72077 is a reply to message #72076]

Tue, 04 March 2003 10:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

options (direct=FALSE,parallel=false,errors=10000)
Load Data
infile 'file.dat' "str 'n'"
into table TABLE1
fields TERMINATED BY ',' trailing nullcols
(
HERE I INCLUDED my column specifications
)

Report message to a moderator

Re: SQL LOADER Data file error [message #72079 is a reply to message #72076]

Tue, 04 March 2003 18:50

alydapan
Messages: 3
Registered: March 2003

Junior Member

TT,2/13/2003,Y,1,DN,ER,++,QQQ,C,
RT,2/13/2003,Y,1,DN,TP,++,555,C,S2

There is no comma at the end of record
or you should put quote between column and add ENCLOSE '"' option in your control file if datatype is character or date.

Report message to a moderator

Previous Topic:	how to solve VTO-4400 problem?
Next Topic:	loading up to 500 records with core dump error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 11:32:27 CDT 2024