Sql Loader Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Sql Loader Problem

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    Sql Loader Problem

    Hi all,

    I am loading some data from one table that was in .csv to Oracle and I have some problem.

    for some reason, data is loaded but I have two problem.

    1. there is only ONE character of the data that was loaded into Oracle and when I look into the log file, I saw the Len in the log file is 1, why was that ???

    2. I have one column and I specify as LONG datatype in Oracle and in .csv file it's MEMO field. for some reason this column is not being loaded and when I view the data in Oracle and it shows LONG instead of the data.

    Can someone tell me what happened here???

    Thanks

  2. #2
    Join Date
    Oct 2002
    Posts
    182
    #1 - if it is comma delimited, then possibly you have a comma in your text. So, when it loads the data, it sees the comma and assumes to move onto the next field.

    #2 - not sure. using long datatypes and attempting to transfer from a MEMO type (foxpro?) is tricky. how long is the data?
    - Cookies

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