Home » RDBMS Server » Server Utilities » AutoCommit after DBMS_DATAPUMP.open (Oracle Database 10g Release - Production)
AutoCommit after DBMS_DATAPUMP.open [message #354315] Fri, 17 October 2008 11:26
Messages: 1
Registered: October 2008
Junior Member
Hi, is there any way to avoid autocommit after DBMS_DATAPUMP.open? I want to rollback changes if export fails, but after DBMS_DATAPUMP.open (even if export fails) changes are commited...

plsql code:

INSERT INTO courier(courier_id, fname) VALUES (1001, 'myname');

v_handle := DBMS_DATAPUMP.open(
operation => 'EXPORT',
job_mode => 'TABLE',
remote_link => NULL,
job_name => v_jobname,
version => 'COMPATIBLE');

This is not the code i am using, just easiest way to invoke the problem.

Previous Topic: import .dmp file using IMP utility for tablespaces
Next Topic: Moving 10g to 9i
Goto Forum:

Current Time: Sat Aug 19 13:54:22 CDT 2017

Total time taken to generate the page: 0.04370 seconds