inserting date with sql*loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: inserting date with sql*loader

  1. #1
    Join Date
    Nov 2000
    Posts
    11
    Hello,

    I am trying to load data into a table but am getting this error.

    ora-01841 :full year must be between -4713 and +9999 and not be 0

    The data to be loaded is in a large .csv file and the dates are of the format 22/11/98 00:00:00 but when the loader get to
    31/5/00 00:00:00 it gives the error message.

    Is there a setting i have to set to enable the insertion of 00 dates.

    thanks

    RJ



  2. #2
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    try this

    timestamp DATE "DD/MM/YY HH:MI:SS"

    Good Luck
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

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