I have a simple table with three columns.
Table name DUMMY20210527
desc DUMMY20210527
PID NUMBER(10)
VDATE DATE
SID NUMBER(10)
Control File
LOAD DATA CHARACTERSET JA16SJIS
APPEND INTO TABLE "DUMMY20210527" fields terminated by '\t' trailing nullcols
(
pid ,
vdate date "YYYY/MM/DD",
sid
)
Data File
a b c
1 2019/01/10 X
When trying to load this file log is showing error in column vdate. however wrong value x is provided in column sid
Log
Record 1: Rejected - Error on table "DUMMY20210527", column VDATE.
ORA-01722: invalid number
Table "DUMMY20210527":
0 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
However if the following file is loaded then proper error message is shown
a b c
X 2019/01/10 1
Log
Record 1: Rejected - Error on table "DUMMY20210527", column PID.
ORA-01722: invalid number
Table "DUMMY20210527":
0 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Oracle version used: Oracle 19c