After table is removed from multimaster replication, ORA-23474, ORA-26500 rep...

刘泽宇

现象：
After the table is removed from multimaster replication, below errors are reported when the table is updated.


ORA-23474: definition of "SCOTT"."EMP" has changed since generation of replication support
ORA-26500: error on caching "SCOTT"."EMP"

原因：
The cleanup was not proper.

处理方法：
Check,  if the trigflag is set on this object.


select obj#, trigflag from tab$ where obj# = <obj# of SCOTT.EMP>

If it is set, then try running the following to remove the triggers



DBMS_REPUTIL.SYNC_UP_REP
PROCEDURE sync_up_rep(canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);

canon_sname
Schema containing the table or materialized view to be synchronized.

canon_oname
Name of the table or materialized view to be synchronized.

i.e.

exec DBMS_REPUTIL.SYNC_UP_REP('SCOTT','EMP');