Home » RDBMS Server » Server Utilities » SQL Loader-350 Syntax error
SQL Loader-350 Syntax error [message #130504] |
Sun, 31 July 2005 17:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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?
|
|
|
|
Re: SQL Loader-350 Syntax error [message #132267 is a reply to message #130549] |
Thu, 11 August 2005 11:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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
|
|
|
Goto Forum:
Current Time: Fri Sep 06 17:45:43 CDT 2024
|