Page 1 of 1
Roll Back in Parallel Jobs
Posted: Wed Feb 06, 2008 1:26 pm
by dwarak_narayana
Hi All,
I am loading records into Oracle database using Oracle Enterprise stage. I want to roll back the inserted records if job aborts. I tried by using env variables like ORAUPSRT_COMMIT_INTERVAL and ORAUPSRT_TIME_INTERVAL. But nothing worked out. Any other ideas plz...
Posted: Wed Feb 06, 2008 1:35 pm
by ArndW
What method are you using to write to oracle? The commit frequency of 0 in the upsert commit interval will force the whole job to be one transaction and will not commit any records if it aborts.
Posted: Wed Feb 06, 2008 1:36 pm
by ArndW
What method are you using to write to oracle? The commit frequency of 0 in the upsert commit interval will force the whole job to be one transaction and will not commit any records if it aborts.
Posted: Wed Feb 06, 2008 1:40 pm
by dwarak_narayana
ArndW wrote:What method are you using to write to oracle? The commit frequency of 0 in the upsert commit interval will force the whole job to be one transaction and will not commit any records if it aborts. ...
Iam using Upsert. I alreday tried by putting commit freequency as 0 but i didnt get the result.
Posted: Thu Feb 07, 2008 1:36 am
by ArndW
Remove the APT_ORA parameters from your job, most likely the timed commit is taking precedence.