Help for Sql*loader error!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Help for Sql*loader error!

  1. #1
    Join Date
    Nov 2000
    Posts
    162
    Hi all,

    I got this error when I loaded data,

    SQL*Loader-510: Physical record in data file (/export/home/thsu/AV_DLR_CO.txt) i
    s longer than the maximum(65535).

    Please suggest what do I need to do. This is urgent, help please!

    Thanks,
    U



  2. #2
    Join Date
    Nov 2000
    Location
    Charlotte
    Posts
    88
    Hey U,

    More information is needed. I.e. what does your .ctl look like how is your data layed out. What's the SQL*Loader command you are using to load...etc.

    Charles

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    no return character

    You have no return character at the end of your record.

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