The Oracle (tm) Users' Co-Operative FAQ

Is there any way to turn replication off within the current session?

Back to index of questions

You should use the DBMS_REPUTIL package:

SQL> execute DBMS_REPUTIL.REPLICATION_OFF;

 ... bulk insert/update/delete

SQL> execute DBMS_REPUTIL.REPLICATION_ON;

Further reading: Oracle8i Management Replication API Reference

Back to top

Back to index of questions