Home » RDBMS Server » Server Utilities » sqlloader load error
sqlloader load error [message #69120] Fri, 02 November 2001 12:29 Go to next message
w j
Messages: 4
Registered: November 2001
Junior Member
hi there,
i have set up the table and the control file,
now when i used the sqlloader to load the data,
it reported error:
SQL*Loader-350: Syntax error at line 5.
Expecting keyword INTO or end of file, found
keyword fields. fields terminated by ","

my control file is:
LOAD data
infile 'stu_data'
append
INTO table student(sid, sfname, slname)
fields terminated by ","

could anyone tell me why? thank you very much!!

----------------------------------------------------------------------

Report message to a moderator

Re: sqlloader load error [message #69121 is a reply to message #69120] Fri, 02 November 2001 12:38 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
LOAD data
infile 'stu_data'
append
INTO table
fields terminated by ","
student(sid, sfname, slname)

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Re: FREE OCP PAPERS
Next Topic: another problem in sqlloader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 08:09:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.