DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Sql_ldr error

  1. #1
    Join Date
    Nov 2002
    Location
    India
    Posts
    22

    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

  2. #2
    Join Date
    Nov 2002
    Posts
    115
    Hi

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


    Regards,
    prasad.
    Prasad

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi

    can u show us whats there in ulcase1 file

    Regards
    Amar

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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
  •  


Click Here to Expand Forum to Full Width