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:
Post a Comment