Showing posts with label ORA-23328: mview base table string . string differs from master table string. string. Show all posts
Showing posts with label ORA-23328: mview base table string . string differs from master table string. string. Show all posts

Saturday, 14 April 2012

ORA-23328: mview base table string . string differs from master table string. string

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.