OraFAQ Forum: Server Utilities » SQL Loader-350 Syntax error

Home » RDBMS Server » Server Utilities » SQL Loader-350 Syntax error

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

SQL Loader-350 Syntax error [message #130504]

Sun, 31 July 2005 17:06

sikyala
Messages: 33
Registered: May 2005

Member

I ran the following control file in sql loader:

LOAD DATA
INFILE 'c:\ntiac\NTMeta.txt'
INTO TABLE ntiac_table
FIELDS TERMINATED BY '\'

(accension_num, unclass_title, personal_author, report_date, media_count, IAC_subject_terms, IAC_FieldGroup, IAC_doc_type,
doc_location, report_class, distrib_limit,distrib_stmt, Abstract, supplementary_note, creation_date, accession_num,
copyright_status, person_responsible)

and I got the following error:

SQL*Loader-350: Syntax error at line 6.
Token longer than max allowable length of 258 chars
te, creation_date, accession_num, copyright_status, person_responsible
^
I don't know what this means and I couldn't find anything to help me to troubleshoot this error. Could someone please explain what is wrong and how I can fix it?

Report message to a moderator

Re: SQL Loader-350 Syntax error [message #130549 is a reply to message #130504]

Mon, 01 August 2005 00:13

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Read these two discussions on the forum.

http://www.orafaq.com/forum/t/46976/70132/

http://www.orafaq.com/forum/t/12160/0/

and try to reduce the size of column names.

regards,
tarun

Report message to a moderator

Re: SQL Loader-350 Syntax error [message #132267 is a reply to message #130549]

Thu, 11 August 2005 11:01

sikyala
Messages: 33
Registered: May 2005

Member

Hi everyone,

FYI I ran the following control file and successfully loaded all 10,774 records. I appreciate everyone who tried to help me.

LOAD DATA
INFILE 'c:\ntiac1\NTMeta.txt'
INTO TABLE ntiac_table
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS

(dummy char (4000),
accens_num char(4000),
unclass_title char(4000),
personal_author char(4000),
report_date char(4000),
media_count char(4000),
IAC_subject_terms char(4000),
IAC_Field_Group char(4000),
IAC_doc_type char(4000),
doc_location char(4000),
report_class char(4000),
distrib_limitation char(4000),
distrib_stmt char(4000),
Abstract char(2500),
supplementary_note char(4000),
create_date char(4000),
accessn_num char(4000),
copyright_status char(4000),
person_responsible char(4000))

Basically I opened the text file in UltraEdit (text editor) and replaced the \ with | as a field delimiter. I also changed the datatype from varchar2 to char. I added TRAILING NULLCOLS just in case there were any fields with no value. Finally, I ran the above control file.

Best,

Raquel

[Updated on: Thu, 11 August 2005 11:07]

Report message to a moderator

Previous Topic:	Using SQL*Loader and UTL_FILE to load and unload large files(i.e. PDF)
Next Topic:	Sql Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 19:21:25 CST 2024