Oracle stage...

sagar deshmukh · Post by **sagar deshmukh** » Fri Jan 16, 2009 7:20 am

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]

Katie09 · Post by **Katie09** » Fri Jan 16, 2009 8:03 am

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.