Oracle Multi-Master Replication - Remove Replication Support

1. To remove replication perform the following on the Master Definition Site:

   CONNECT repadmin/repadmin@tsh1 
   -- Stop replication
   EXECUTE Dbms_Repcat.Suspend_Master_Activity(gname=>'MYREPGRP'); 

   -- Delete replication groups
   EXECUTE Dbms_Repcat.Drop_Master_Repobject('SCOTT', 'EMP', 'TABLE');
   EXECUTE Dbms_Repcat.Remove_Master_Databases('MYREPGRP', 'TSH2.WORLD');

2. Next do the following on all Master Sites:
   CONNECT repadmin/repadmin@tsh1 

   -- Remove private databse links to other master databases
   EXECUTE Dbms_Repcat.Drop_Master_Repgroup('MYREPGRP');
   DROP DATABASE LINK TSH2.WORLD; 

   -- Remove any leftover jobs (see DBA_JOBS for job numbers)
   EXECUTE Dbms_Job.Remove(62);
   EXECUTE Dbms_Job.Remove(63); 

   CONNECT sys@tsh1 

   -- Remove the REPADMIN user
   EXECUTE Dbms_Defer_Sys.Unregister_Propagator(username=>'REPADMIN');
   EXECUTE
   Dbms_Repcat_Admin.Revoke_Admin_Any_Schema(username=>'REPADMIN');
   DROP USER repadmin CASCADE; 

   -- Drop public database links to other master databases
   DROP PUBLIC DATABASE LINK TSH2.WORLD;