Sql_ldr error

[sgnerd]

Hi,
while I am practising with Sql*loader and working out an example in 9iDocumentation, i am executing the following

At the SQL prompt, execute the SQL script for this case study, as follows:
SQL> @ulcase1
This prepares and populates tables for the case study and then returns you to your system prompt.

But I got an error msg, as follows

SP2-0042: unknown command "LOAD DATA" - rest of line ignored.
SP2-0042: unknown command "INFILE *" - rest of line ignored.
SP2-0734: unknown command beginning "INTO TABLE..." - rest of line ignored.
SP2-0734: unknown command beginning "FIELDS TER..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
10

Anybody can help me in that.

Thanks in advance

[prasadvd]

Hi

you just define all those commands in control file and place it
in exact location.


Regards,
prasad.

[adewri]

Hi

can u show us whats there in ulcase1 file

Regards
Amar

[agasimani]

Better learn basics of Loader first. You will get samples on this url:

http://otn.oracle.com/docs/products
/oracle8i/doc_library/817_doc/server.817/a76955/ch04.htm#534