标题: After table is removed from multimaster replication, ORA-23474, ORA-26500 rep... [打印本页] 作者: 刘泽宇 时间: 7 天前 标题: 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.