$APT_ORAUPSERT_COMMIT_ROW_INTERVAL
Posted: Tue Nov 09, 2004 3:00 pm
Hi
I have set $APT_ORAUPSERT_COMMIT_ROW_INTERVAL=1000000000 in a fact load job that typically handles volumes of 100,000.
The idea is to do a database commit after all the records are inserted. If the job aborts, Oracle should do a rollback.
However, I find that the inserted records are getting committed when a job aborts. A rollback is not happening.
Any inputs ?
Thanks
Ravi Mohan
I have set $APT_ORAUPSERT_COMMIT_ROW_INTERVAL=1000000000 in a fact load job that typically handles volumes of 100,000.
The idea is to do a database commit after all the records are inserted. If the job aborts, Oracle should do a rollback.
However, I find that the inserted records are getting committed when a job aborts. A rollback is not happening.
Any inputs ?
Thanks
Ravi Mohan