-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|