| How to remove entry from dba_repgroup [message #547924] |
Mon, 19 March 2012 01:03  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Guys,
SELECT * FROM dba_repgroup;
returns a single row sname='VL_REPG', gname='VL_REPG', owner='PUBLIC'.
How do I get rid of it?
select * from dba_registered_mview_groups;
returns
no rows selected
select * from dba_objects where object_name = 'VL_REG';
returns
no rows selected
I triedSQL> l
1 BEGIN
2 dbms_repcat.comment_on_mview_repsites(gowner => 'PUBLIC', gname => 'VL_REPG', COMMENT => 'asdf');
3* END;
SQL> /
BEGIN
*
ERROR at line 1:
ORA-23314: database is not a materialized view site for "PUBLIC"."VL_REPG"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 7376
ORA-06512: at "SYS.DBMS_REPCAT", line 509
ORA-06512: at line 2
Any suggestions on how I get rid of this dba_repgroup.
David
|
|
|
|
| Re: How to remove entry from dba_repgroup [message #547935 is a reply to message #547924] |
Mon, 19 March 2012 02:15  |
John Watson
Messages: 8949
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Could it be a multimaster replication group?orcl> exec dbms_repcat.create_master_repgroup('mygroup')
PL/SQL procedure successfully completed.
orcl> SELECT * FROM dba_repgroup;
SNAME M STATUS SCHEMA_COMMENT
------------------------------ - --------- -------------------------------------
GNAME FNAME R OWNER
------------------------------ ------------------------------ - ---------------
MYGROUP Y QUIESCED
MYGROUP N PUBLIC
orcl> exec dbms_repcat.drop_master_repgroup('mygroup')
PL/SQL procedure successfully completed.
orcl> SELECT * FROM dba_repgroup;
no rows selected
orcl> |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
