Thanks!

-----Original Message-----
From: Chirag Dalal [mailto:[Email address protected]
Sent: Monday, March 05, 2007 12:35 PM
To: Sikyala, Raquel
Subject: RE: SQL*Loader-350: Syntax error at line 4.

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


Check your spelling for termininated... It should be terminated Thanks


-----Original Message-----
From: Sikyala Raquel
[Email address protected]
Sent: Monday, March 05, 2007 12:15 PM
To: LazyDBA Discussion
Subject: SQL*Loader-350: Syntax error at line 4.


I am trying to load some data using sqlldr and I am getting a syntax
error.
SQL*Loader-350: Syntax error at line 4.
Expecting "(", found "termininated".
fields termininated by '|||'

Here is my control file:

load data
infile 'tr.txt'
into table tr
fields termininated by '|||'
TRAILING NULLCOLS
(AccessionNumber CHAR (255),
DateGenerated DATE,
CitationStatus CHAR (20),
CitationClassification CHAR (50),
CorporateAuthor CHAR (255),
PersonalAuthor CHAR (255),
UnclassifiedTitle CHAR (2000),
TitleClassification CHAR (50),
ReportDate DATE,
PaginationOrMediaCount number,
PaginationCode number,
ItemCost number,
ReportNumber number,
MonitorAcronym CHAR (255),
MonitorSeries CHAR (255),
ReportClassification CHAR (50),
DistributionCode CHAR (1),
DescriptorClassification CHAR (50),
IdentifierClassification CHAR (50),
AbstractClassification CHAR (50),
SourceCode CHAR (255),
GeopoliticalCode CHAR (255),
OrganizationTypeCode CHAR (255),
DocumentLocation CHAR (255),
ChangeAuthority CHAR (255),
DateCitationUpdated DATE,
Abstract CHAR (4000),
Descriptor CHAR (4000),
FieldsAndGroups CHAR (4000),
Identifier CHAR (20),
handle CHAR (50),
PdfFileSize CHAR (20))

I don't know why it is expecting a open parens. Could someone please
help me?

Raquel Sikyala



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page