Wednesday, January 12, 2011

Drop Multimaster Replication Installation

1-Purge all transactions from Queue
SQL> conn repadmin/repadmin

SQL> DECLARE
temp INTEGER;
BEGIN
temp := DBMS_DEFER_SYS.PURGE (
purge_method => DBMS_DEFER_SYS.purge_method_precise);
END;
/

2-Drop all Replication DBlinks between databases

3-Drop the Replication group from all sites

SQL> conn repadmin/repadmin

SQL> BEGIN
DBMS_REPCAT.drop_master_repgroup (gname => '"GROUPC"',
drop_contents => FALSE,
all_sites => FALSE
);
END;
/

4-Drop Replication users from both databases

SQL> Conn / as sysdba
SQL> drop user repdba cascade;
SQL> drop user reprec cascade;
SQL> drop user repprop cascade;
SQL> drop user repadmin cascade;

No comments: