Roll Back in Parallel Jobs

dwarak_narayana · Post by **dwarak_narayana** » Wed Feb 06, 2008 1:26 pm

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...

ArndW · Post by **ArndW** » Wed Feb 06, 2008 1:35 pm

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.

ArndW · Post by **ArndW** » Wed Feb 06, 2008 1:36 pm

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.

dwarak_narayana · Post by **dwarak_narayana** » Wed Feb 06, 2008 1:40 pm

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.

ArndW · Post by **ArndW** » Thu Feb 07, 2008 1:36 am

Remove the APT_ORA parameters from your job, most likely the timed commit is taking precedence.