problem using sqlldr(2 Merged) [message #520287] |
Sat, 20 August 2011 10:08 |
|
p40l3tt0
Messages: 9 Registered: August 2011
|
Junior Member |
|
|
Good Morning,
i have the problem with sqlldr.
This is the table:
Name Null? Type
----------------------------------------- -------- ----------------------------
A NUMBER(9)
B NUMBER(9)
C NUMBER(9)
This is the ctl file:
LOAD DATA
INFILE './PROVA.txt'
REPLACE
INTO TABLE prova
FIELDS TERMINATED BY "\t"
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
A,
B,
C
)
This is the log file:
Record 1: Rejected - Error on table PROVA, column A.
ORA-01722: numero non valido
Record 2: Rejected - Error on table PROVA, column A.
ORA-01722: numero non valido
Record 3: Rejected - Error on table PROVA, column A.
ORA-01722: numero non valido
Help me!!! I'm crazy for error ORA-01722
Thank you very much!!
Bye bye
|
|
|