ORA-23363: mismatch of mview base table “string” at master and mview site ORACLE 报错 故障修复 远程处理
文档解释
ORA-23363: mismatch of mview base table string at master and mview site
Cause: The name of the base table of the materialized view at the master site is different from the base table at the materialized view site. This error may arise during offline instantiation of materialized views.
Action: Retry offline instantiation with a materialized view name less than 24 bytes
ORA-23363 错误指的是在主库级别与 Materialized View(MV)的基表有不一致的情况,官方解释:
This means there is a mismatch of the Mview base table at the master and Mview site. It is due to the fact that one or more of the tables participating in the Materialized View at the master site has been altered in some way where the Mview site does not have the latest information about the table.
1、在主库上增加了一个列,但是在MV上没有更新相应的变更。
2、在主库上改变了表结构,但是MV上没有及时同步。
3、在主库上删除了一个表,但是在MV上没有移除。
一般处理方法及步骤1、确定和分析表结构变更,判断变更是否能在 MV 上执行;
2、在修改确定后,先refresh 对应指定MV ;
3、确定完成更新MV 后,重新编译上面变更对应的sql;
4、重新跟新对应表中变更,重新更新MV;
5、再次refresh 对应MV,确定无误,完成操作;
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 ORA-23363: mismatch of mview base table string at master and mview site ORACLE 报错 故障修复 远程处理
相关文章
- ORA-01299: dictionary string corresponds to a different database incarnation ORACLE 报错 故障修复 远程处理
- ORA-22345: recompile type string.string before attempting this operation ORACLE 报错 故障修复 远程处理
- ORA-23325: parameter type is not string ORACLE 报错 故障修复 远程处理
- ORA-23441: object does not exist for refresh group template ORACLE 报错 故障修复 远程处理
- ORA-27058: file I/O question parameter is invalid ORACLE 报错 故障修复 远程处理
- ORA-28183: proper authentication not provided by proxy ORACLE 报错 故障修复 远程处理
- ORA-32164: Method called on Invalid Connection type ORACLE 报错 故障修复 远程处理
- ORA-38802: edition does not exist ORACLE 报错 故障修复 远程处理
- ORA-48119: error encountered when attempting to remove a file [string] [string] ORACLE 报错 故障修复 远程处理
- ORA-48936: The number of relations exceeds maximum number [string] ORACLE 报错 故障修复 远程处理
- ORA-54038: Virtual column cannot be encrypted ORACLE 报错 故障修复 远程处理
- ORA-54523: inner rings of same outer ring cannot touch more than once ORACLE 报错 故障修复 远程处理
- ORA-07454: queue timeout, string second(s), exceeded ORACLE 报错 故障修复 远程处理
- ORA-08341: On nCUBE, this command can only be executed from instance 1. ORACLE 报错 故障修复 远程处理
- ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message ORACLE 报错 故障修复 远程处理
- ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns ORACLE 报错 故障修复 远程处理
- ORA-15105: missing or invalid FAILGROUP name ORACLE 报错 故障修复 远程处理
- Oracle故障:系统无法启动(oracle起不来)
- Oracle 删除目录的方法(oracle删除目录)
- 学习Oracle编程:语法技巧及应用(oracle编程语法)
- 库Oracle资料库:掌握最新的知识宝库(oracle 资料)
- Oracle如何让密码永不过期(oracle修改密码过期)
- 知名企业家Larry Ellison掌管Oracle公司(oracle公司的老板)
- Oracle人员排序技术指南(oracle 人员排序)
- Oracle IP 连接问题症结出在何处(oracle ip连不上)