2 Replies Latest reply: Nov 22, 2012 12:48 AM by bharathDBA RSS

    SQLLDR issue in populating timestamp data

    bharathDBA
      Hi,

      I wrote a SQLLDR control script.In that,one column of a table to be populated with timestamp data.

      The format of the data that is in data file is like :2010-09-14.11.42.11.972000.

      When I run the sqlldr script,It is giving bad records throwing the error

      Record 10:Rejected - Error on table TABLE1, column ISSUE_DATE.
      ORA-01843:not a valid month.

      Can someone help me with this issue...

      Do I need to change my script to convert month number to 3 character name:eg 09 to SEP ??

      Regards,
      Bharath