importing data using sql loader in oracle 9i

[tahir_mehmood]

Respected sir,
I am facing problem while importing data from text file to oracle 9i using sql loader.Folloing error occured while importing data

Record 1: Rejected - column BILL_MONTH.
ORA-01858: a non-numeric character was found where a numeric was expected

Record 2: Rejected column BILL_MONTH.
ORA-01843: not a valid month

the data type of bill_month is date and i want to enter following data
16/11/2006 0:00:00

in control file i declare field like this
BILL_MONTH date "DD/MM/YYYY HH24:MI:SS"

please help me regarding this.
khuda hafiz

[amirtai]

Hti Tahir

It often happend with date/time type data. what you need to do is add a temporary column to the table with type CHAR and insert all your data of BILL_MONTH overthere. You can issue command below to replace all your actual values in BILL_MONTH column.


SQL> UPDATE tablename
SET bill_month = TO_DATE(temp_col,'DD/MM/YYYY HH24:MI:SS');