Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Remove Replication...

mohsin3Apr 9 2010 — edited Apr 10 2010
Dear 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....

Comments

Babu Baskar
mohsin3 wrote:
Dear 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....
Try from master site

1.

BEGIN
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY(
gname => '"<<your gname>>"');
END;

2.

EXECUTE Dbms_Repcat.Drop_Master_Repobject('WEAVING','SALES_CONTRACT_MST','TABLE');

3.

PROMPT *** Resuming Replication Activity of Group SAMIQC
BEGIN
DBMS_REPCAT.RESUME_MASTER_ACTIVITY(
gname => '"<<your gname>>"');
END;
/


Babu
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 8 2010
Added on Apr 9 2010
#database-key-features, #replication
1 comment
2,421 views