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


Oracle LazyDBA home page