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