最近在搭建生产环境的ogg时,遇到了MVIEW的问题
If your source system has materialized views, please pay attention to the following:
Limitations of support for materialized views (MVs)
● Materialized views created WITH ROWID are not supported.
● The materialized view log can be created WITH ROWID.
● The source table must have a primary key.
● Truncates of materialized views are not supported. You can use a DELETE FROM statement.
● Some Oracle GoldenGate initial-load methods do not support LOBs in a materialized view.
● For Replicat, the materialized view must be updateable.
● Full refreshes are supported for Oracle 10g and later.
A solution is to change the materialized views “FOR UPDATE” before replicating this table.
If you don’t do this REPLICAT will abend with this message:
2011-10-15 21:14:44 WARNING OGG-00869 OCI Error ORA-01732: data manipulation operation not lega
If your source system has materialized views, please pay attention to the following:
Limitations of support for materialized views (MVs)
● Materialized views created WITH ROWID are not supported.
● The materialized view log can be created WITH ROWID.
● The source table must have a primary key.
● Truncates of materialized views are not supported. You can use a DELETE FROM statement.
● Some Oracle GoldenGate initial-load methods do not support LOBs in a materialized view.
● For Replicat, the materialized view must be updateable.
● Full refreshes are supported for Oracle 10g and later.
A solution is to change the materialized views “FOR UPDATE” before replicating this table.
If you don’t do this REPLICAT will abend with this message:
2011-10-15 21:14:44 WARNING OGG-00869 OCI Error ORA-01732: data manipulation operation not lega