-
Hi guys,
I am trying to load a table with two columns(id number,num varchar2(10)) from a text file.I am getting the following error. How to go about solving it?
**************************************
Table CRDB.TEST1, loaded from every logical record.
Insert option in effect for this table: INSERT
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID FIRST 1 CHARACTER
NUM NEXT 1 CHARACTER
Record 1: Rejected - Error on table CRDB.TEST1, column ID.
ORA-01722: invalid number
*********************************************
Also, for end of file should we mention something at the end of text file like a backslash etc?
thanks
manjunath
-
Looks like there is a mismatch in datatype, the column "id" is number but is being inserted as a character datatype.
hope this helps,
vidhya
-
Hi,
If you could send your control file ,then probably we couls answer it more correctly.
Anand
