Home » Server Options » Replication » Deleting Replication Group
Deleting Replication Group [message #75560] Thu, 21 October 2004 10:48 Go to next message
Clark
Messages: 3
Registered: October 2004
Junior Member
What am I doing wrong?

Pretty much same as my other post but in reverse:

 

Begin
   DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY ('HIP_GRP');
End;

EXECUTE Dbms_Repcat.Drop_Master_Repobject('DDW_DBA', 'HIP_FACT_TBL', 'TABLE');
EXECUTE Dbms_Repcat.Remove_Master_Databases('HIP_GRP', 'remote.site1');
EXECUTE Dbms_Repcat.Remove_Master_Databases('HIP_GRP', 'remote.site2');

The remove_master_databases produces an entry in repcatlog that says AWAIT_CALLBACK at the master and READY at all masters.  Run all the jobs and nothing happens.
Re: Deleting Replication Group [message #75563 is a reply to message #75560] Tue, 26 October 2004 04:23 Go to previous message
Deon
Messages: 6
Registered: September 2004
Junior Member
Run this in SQL Plus

DELETE FROM ALL_REPCAT WHERE SNAME = 'HIP_GRP';

commit;
Previous Topic: Creating Replication Group
Next Topic: Multimaster Replication
Goto Forum:
  


Current Time: Thu Mar 28 15:34:48 CDT 2024