Disable Multimaster Replication In A Session

A very useful feature in Oracle Advanced Replication is to Disable Replication in a SQL session.
It is used to correct the data if you face a conflict in data between the Master Definition and Master Sites in some tables in your Replication environment.

In the following example we will discuss how it works:

Master Definition Site: ORCL1
Master Site: ORCL2

Steps:

1- Connect to SQLPLUS on the Site has the confilct issue with repadmin user
SQL> conn repadmin/repadmin@ORCL2

2- Disable the replication in this session
SQL> BEGIN
DBMS_REPUTIL.REPLICATION_OFF;
END;
/

3- Modify the tables you want
SQL> INSERT INTO SCOTT.EMP SELECT * FROM SCOTT.EMP@ORCL1;

SQL> COMMIT;

4- Enable the replication in this session again
SQL> BEGIN
DBMS_REPUTIL.REPLICATION_ON;
END;
/