Re-adding a master site

From: Jake <Im_at_nottelling.com>
Date: Thu, 19 Dec 2002 10:37:40 -0600
Message-ID: <atssk3$l3o$1@bob.news.rcn.net>

Hi,

at my master definition site I executed:

BEGIN
dbms_repcat.remove_master_databases(
gname => 'FVCS_REP',
master_list=>'TR01.WORLD');
END;
/

I didn't do anything on my master site (TR01.WORLD). The TR01 is still totally configured for replication (all the tables, data, master group, dblinks...). How can I add the site back into replication? Using all the the existing objects and data.

When I try (at the master definition site):

1 begin
2 dbms_repcat.add_master_database(
3 gname => 'FVCS_REP', master => 'TR01', 4 use_existing_objects => TRUE,
5 copy_rows => FALSE, comment => '',
6 propagation_mode => 'ASYNCHRONOUS');
7* end;
SQL> /
begin
*
ERROR at line 1:

ORA-23374: object group "PUBLIC"."FVCS_REP" already exists
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 1952
ORA-06512: at "SYS.DBMS_REPCAT", line 121
ORA-06512: at line 2

Thanks
Jake Received on Thu Dec 19 2002 - 10:37:40 CST