SQL Loader: "One Row Error, No Full Import" Not Working with CTL Script - Help
Hi Team，
It is necessary to control that if there is an error in any single row of a single file, the entire data of the file will not be imported into the interface table. Can it be achieved through SQL Loader? If so, the following CTL script is currently used, but the expected effect is not achieved. Please point out the problems. Thank you.
options(skip=1,BINDSIZE=20971520, ROWS=10000, READSIZE=20971520, ERRORS=0)
load data
infile '$1'
append into table "XXXXXX"
fields terminated by '|'
Optionally enclosed by '"'
Tagged:
0