Page 1 of 1
Oracle stage...
Posted: Fri Jan 16, 2009 7:20 am
by sagar deshmukh
Code: Select all
i am loading data into oracle tables and suppose the jobs gets aborted at 101st record...so does it means that it has insertred 100 records into the table..
and if so,....and if we dont want the job should commit any records if it gets aborted then what we need to do..
[/quote]
Posted: Fri Jan 16, 2009 8:03 am
by Katie09
i am loading data into oracle tables and suppose the jobs gets aborted at 101st record...so does it means that it has insertred 100 records into the table..
and if so,....and if we dont want the job should commit any records if it gets aborted then what we need to do
Hi..
It depends on the commit interval. If you set it less, you transaction will be completed and database will have parital results..
However it is having issues with performance as if commit interval is less, data will be written to db and i/o will increase.