Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    44

    Unanswered: Problem with Sql*Loader

    Hi All,

    I am using Oracle 8.1.7 Version. I have a comma seperated data file. There is one column data which has more than 255 characters in csv file. When i run the control file, all the records which has more than 255 character are getting rejected. Can anyone please let me know, how to load the column data into database table which has more than 255 characters.


    Thanks in Advance
    Thanks and Regards,
    Mahesh

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink

    SQL*Plus max default character length is 255 unless otherwise specified, set that column to your MAX character length:
    Code:
    ...
    COL1 CHAR(4000),

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    44
    Hi,

    It worked... Thanks
    Thanks and Regards,
    Mahesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •