Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re-adding a master site
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