importing data using sql loader in oracle 9i
Posted: Thu Jan 04, 2007 7:19 am
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
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