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:
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.
Anybody can help me in that.
Thanks in advance
you just define all those commands in control file and place it
in exact location.
can u show us whats there in ulcase1 file
Better learn basics of Loader first. You will get samples on this url:
Click Here to Expand Forum to Full Width