| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
