Home » Server Options » Replication » How to remove entry from dba_repgroup (Oracle 11.2.0.1)
How to remove entry from dba_repgroup [message #547924] Mon, 19 March 2012 01:03 Go to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 tried
SQL> 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 Go to previous messageGo to next message
John Watson
Messages: 4793
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>
Re: How to remove entry from dba_repgroup [message #548030 is a reply to message #547935] Mon, 19 March 2012 18:25 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
John,

Thanks. That worked perfectly.

David
Previous Topic: GoldenGate
Next Topic: Materialized Views on 3 database
Goto Forum:
  


Current Time: Sun Nov 23 20:58:31 CST 2014

Total time taken to generate the page: 0.04340 seconds