Remove Replication...
mohsin3Apr 9 2010 — edited Apr 10 2010Dear all
There was replication between 2 servers ,but about 6 months back a server on which the data was replicated was totally closed and obviously no need of replication now.but we came to know that when we change any replicated table we get error :
ORA-23474: definition of "WEAVING"."SALES_CONTRACT_MST" has changed since generation of replication support
Tried to remove group as :
EXECUTE Dbms_Repcat.Drop_Master_Repobject('WEAVING','SALES_CONTRACT_MST','TABLE');
but got error
ERROR at line 1:
ORA-06550: line 1, column 8:
PLS-00352: Unable to access another database 'ORCL.WEAVCDC.BTLWCDC.BTLPDC.COM'
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS@ORCL.WEAVCDC.BTLWCDC.BTLPDC.COM' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06550: line 1, column 7:
PLS-00352: Unable to access another database 'ORCL.WEAVCDC.BTLWCDC.BTLPDC.COM'
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS@ORCL.WEAVCDC.BTLWCDC.BTLPDC.COM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_REPCAT_UTL4", line 119
ORA-06512: at "SYS.DBMS_REPCAT_UTL4", line 554
ORA-06512: at "SYS.DBMS_REPCAT_UTL4", line 2723
ORA-06512: at "SYS.DBMS_REPCAT", line 643
ORA-06512: at line 1
plsease help....