OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Help!!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator