SQL*Loader problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQL*Loader problem

  1. #1
    Join Date
    Nov 2001
    Posts
    6

    Question

    Hi again,

    I'm trying to load a comma delimited flatfile into a database, which contains a CLOB column and am getting an error. Please help if you can! Here's what my control file looks like:

    LOAD DATA
    INFILE 'E:\HUB_STORE.txt'
    BADFILE 'E:\HUB_STORE.bad'
    DISCARDFILE 'E:\HUB_STORE.dsc'

    INTO TABLE "HUB_STORE"
    REENABLE DISABLED_CONSTRAINTS

    FIELDS TERMINATED BY ','
    TRAILING NULLCOLS

    (MSG_ID,
    SENDER_ID,
    RECEIVER_ID,
    MSG_TYPE_ID,
    MSG_STATUS_ID,
    TRANS_ID,
    DATA,
    ATTEMPTS,
    TIME_CREATED,
    TIME_OF_LAST_ATTEMPT,
    TIME_COMPLETED,
    NOTIF_CREATED)


    I get the error message:

    SQL*Loader-350: Syntax error at line 18.
    Expecting field-name, found keyword data.
    DATA,
    ^

    As this is my first time loading data into a database using SQL*Loader, I'm at a loss. The CLOB column can be very large in some cases as it's basically an XML document within that column. Can anyone enlighten me as to what exactly the problem and possible solution are?

    Many thanks,
    David

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    You might have to add a filler field.
    RES_FILE FILLER CHAR

    See the following links for more info on loading LOB data:

    http://otn.oracle.com/docs/products/...ch03.htm#12968

    http://otn.oracle.com/docs/products/.../ch04.htm#8383 (for examples)

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Feb 2001
    Posts
    125
    HI


    it seems like error is due to u r using reserved 'DATA'
    in ur fields

    TRANS_ID,
    DATA, (perhaps error is due to this on)
    ATTEMPTS

    change the name of field as DATA1 in table and in control file
    try again.



    P.Soni

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    PSoni is right, DATA is one of the SQL LOADER RESERVEd words.
    You won't see this error if you're just using SQL/PLSQL.

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