Help!! [message #72539] |
Sun, 13 July 2003 06:42 |
badri anand
Messages: 2 Registered: July 2003
|
Junior Member |
|
|
I am a computer science student in the UK and I got your contact when I was searching for oracle related stuff on the internet. I am a beginner in databases. I would like to know about SQL *Loader. I would like to load multiple files into a field of a table. How do I use a loop to do that. How do I perform that using SQL * Loader. I am using SQLPlus Worksheet and I am using Oracle 9.
When I try this following code in SQLPlus Worksheet:
sqlldr scott/tiger control=point.ctl
load data
infile 'H:po.txt'
into table pt
fields terminated by "," optionally enclosed by '"'
( point )
I am getting this error:
SP2-0734: unknown command beginning "into table..." - rest of line ignored.
SP2-0734: unknown command beginning "fields ter..." - rest of line ignored.
SP2-0734: unknown command beginning "sqlldr sco..." - rest of line ignored.
SP2-0042: unknown command "load data" - rest of line ignored.
SP2-0734: unknown command beginning "infile 'H:..." - rest of line ignored.
SP2-0734: unknown command beginning "into table..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "fields ter..." - rest of line ignored.
I don't know what to do. Can you pls help me with this. I have been trying to search for this kind of info for a long time and finally found your site. Your help would be very much appreciated. It would be very kind of you if you could send me a step by step procedure on what needs to be done. I'll attach a sample point file. Like this I am having around 250 point files from which the data has to be loaded into a field of a table. Looking forward for your help as soon as possible,
thanking you,
badri anand
|
|
|
Re: Help!! [message #72540 is a reply to message #72539] |
Sun, 13 July 2003 12:37 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
i beleive, you cannot use sqlplus worksheet or sqlplus
to invoke sql*loader.
You have to the command prompt and invoke the sql*loader
|
|
|