-
Sql_ldr error
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
-
Hi
you just define all those commands in control file and place it
in exact location.
Regards,
prasad.
Prasad
-
Hi
can u show us whats there in ulcase1 file
Regards
Amar
-
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
Agasimani
OCP(10g/9i/8i/8)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|