Home » Server Options » Replication » deleted repgroup but it is showing in DBA_REPOBJECT.URGENT PL.
deleted repgroup but it is showing in DBA_REPOBJECT.URGENT PL. [message #75614] Mon, 07 February 2005 02:15
satish
Messages: 112
Registered: September 2000
Senior Member
DEAR SIR...

I have a group 'USERS_MG'

3 tables (users,user_access,forms_mast) r in the 'USERS_MG' Group.

i deleted the the users_mg group using ..

exec dbms_repcat.drop_master_repgroup(gname =>'users_mg',drop_contents =>false,all_sites =>true);

it was run successfully.

if i query DBA_REPSITES and DBA_REPGROUP the group 'users_mg' is not exist In all the sites including masterdef site.

BUT IF I QUERY DBA_REPOBJECT USERS_MG STATUS IS VALID IN MASTERDEF SITE ONLY IN OTHER SITES THE GROUP IS NOT SHOWING......

if i create a new group and trying to add the the tables users,user_access and forms_mast i am not able to create it because if i query
select oname,status from dba_repobject;
the status is showing valid...
if i try to drop the object now using
dbms_repcat.drop_master_repobject it is giving error

ora-23312 not the masterdef according to 'dblink'

so what shoul i do...???

thanq
satish
Previous Topic: Error Whle Refreshing Materialized View---Very Urgent
Next Topic: URGENT!Please help .
Goto Forum:
  


Current Time: Thu Mar 28 10:44:02 CDT 2024