capture rejects using Oracle Enterprise edition stage
Posted: Mon Apr 06, 2009 1:59 pm
Hi All,
How do I capture a reject file with sql code and sql error using oracle enterprise edition stage.
I am trying to insert 100,000 records into oracle data base. if there is only 1 bad record it rejects all the 100,000 records with a sql code 1403.
I want to capture only the specific record(s) that get rejected from Oracle enterprise edition stage in the reject file with sql error and sql code. it helps me to debug the data if that is case.
thanks
Mark
How do I capture a reject file with sql code and sql error using oracle enterprise edition stage.
I am trying to insert 100,000 records into oracle data base. if there is only 1 bad record it rejects all the 100,000 records with a sql code 1403.
I want to capture only the specific record(s) that get rejected from Oracle enterprise edition stage in the reject file with sql error and sql code. it helps me to debug the data if that is case.
thanks
Mark