The Oracle (tm) Users' Co-Operative FAQ

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


Author's name: Vadim Grepan

Author's Email: vadim@elibron.com, kezal@mail.ru 

Date written: 04-Sep-2001

Oracle version(s): 8i (8.1.*)

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