ORA-23328: mview base table “string”.”string” differs from master table “string”.”string”
Cause: When creating a materialized view through repcat, the materialized view base table name did not match a replicated table name at the master.
Action: Change the materialized view ddl to use the same base table as the replicated table name at the master.
ORA-23328错误指示MVIEW的基础表(BASETABLE)与主表(MASTERTABLE)不匹配,即它们在定义和结构上不匹配。
1. 检查MV的基础表与主表的定义是否完全相同,
2. 如果不同,可以更改基础表的定义,让其与主表完全匹配。
3. 用dbms_mview重新创建该MVIEW,以此来解决ORA-23328错误。