DSXchange

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.

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