ORA-32331: type “string”.”string” is incompatible with the master site ORACLE 报错 故障修复 远程处理
ORA-32331: type string . string is incompatible with the master site
Cause: A type used by the materialized view was found to be incompatible with its coressponding type on the master site. This could be because the type does not exist on the master site or has been evolved to a different version from that on the materialzied view site.
Action: Make sure that the types used by the materialized view are the same on both the materialized view and master sites.
ORA-32331 错误是由Advanced Replication报出的,它表示在master site和replicated site之间的类型不一致导致的。
ORA-32331: type string . string is incompatible with the master site
Cause: A replicated object contains a column with a type incompatible with the master site.
Action: Create the replicated object with an appropriate type at the master site and then at the replicated site.
在复制环境(通常是Oracle端)中,由于master site表中字段和replicated site表中字段的数据类型不一致,导致报出此错误。此时必须将主从端的字段同步,即将master site的字段的数据类型修改成与replicated site表字段的数据类型一致。
一般处理方法及步骤1、首先查看master site表和replicated site表的不一致字段,将这些字段的信息记录下来;
2、然后在master site和replicated site同步修改这些字段:将master site中的字段修改为与replicated site一致;
3、再次添加这些复制字段;
4、最后,确认复制进程正常运行,确认没有其他异常现象发生。
相关文章
- ORA-01078: failure in processing system parameters ORACLE 报错 故障修复 远程处理
- ORA-19972: ALTER DATABASE RECOVER TO LOGICAL requires one instance left ORACLE 报错 故障修复 远程处理
- ORA-24054: cannot propagate to an Oracle 8.0.3 release or lower release ORACLE 报错 故障修复 远程处理
- ORA-28039: cannot validate Kerberos service ticket ORACLE 报错 故障修复 远程处理
- ORA-31088: object “string”.”string” depends on the schema ORACLE 报错 故障修复 远程处理
- ORA-31481: change source string is not a HotLog change source ORACLE 报错 故障修复 远程处理
- ORA-32404: snapshot log uses Change Data Capture which is not enabled for this database ORACLE 报错 故障修复 远程处理
- ORA-38504: this operator not allowed with the configured attribute set ORACLE 报错 故障修复 远程处理
- ORA-39946: Nondefault token table encountered. ORACLE 报错 故障修复 远程处理
- ORA-47404: NULL trust level for Factor string ORACLE 报错 故障修复 远程处理
- ORA-56600: DRCP: Illegal call [string] ORACLE 报错 故障修复 远程处理
- ORA-02269: key column cannot be of LONG datatype ORACLE 报错 故障修复 远程处理
- ORA-02433: cannot disable primary key – primary key not defined for table ORACLE 报错 故障修复 远程处理
- ORA-02846: Unkillable server ORACLE 报错 故障修复 远程处理
- ORA-12029: LOB columns may not be used as filter columns ORACLE 报错 故障修复 远程处理
- ORA-13265: geometry identifier column string in table string is not of type NUMBER ORACLE 报错 故障修复 远程处理
- ORA-13406: null or invalid GeoRaster object for output ORACLE 报错 故障修复 远程处理
- ORA-16179: incremental changes to “string” not allowed with SPFILE ORACLE 报错 故障修复 远程处理
- 利用Oracle 多表联查提升效率(oracle多表效率)
- Oracle存储过程:实现自动化处理的利器(oracle存储过程内容)
- Oracle数据库开启,提升数据处理效率(oracle数据库开启)
- Oracle关闭连接超时提升数据安全性(oracle关闭连接超时)
- Oracle中特殊字段的使用方法(oracle中特殊字段)
- Oracle中新建一个数据库的步骤详解(oracle中如何创建库)