Loading SELECTIVE Data using SQL Loader
Posted on 2004-08-23
I need to use SQL loader to load data in Oracle.
Following issues need to be considered during data load:
1- If primary key clash occurs during load, ignore that record.
2- In order to load go successful, I *NEED TO MAKE SURE* that
certain fields are not null. I can not make those columns NOT NULL
in DB as for some other LOADS/Application they need to be NULL in table definition.
IF ANY REQUIRED COLUMN is found NULL whole LOAD should rollback.
So question is how to define certain columns to be REQUIRED in .ctl file and
how to rollback whole load as soon as a record is encountered having required field with NULL value.
Thanks a lot