2 Replies Latest reply on Nov 22, 2012 6:48 AM by bharathDBA

    SQLLDR issue in populating timestamp data


      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-

      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 ??