ogg 同步 物化视图创建限制：
Materialized views are supported by Extract in classic and integrated modes with the following limitations.
1.Materialized views created WITH ROWID are not supported.
2.The materialized view log can be created WITH ROWID.
3.The source table must have a primary key.
4.Truncates of materialized views are not supported. You can use a DELETE FROM statement.
5.DML (but not DDL) from a full refresh of a materialized view is supported. If DDL support for this feature is required, open an Oracle GoldenGate support case.
6.For Replicat the Create MV command must include the FOR UPDATE clause
7.Either materialized views can be replicated or the underlying base table(s), but not both.
Materialized views are supported by Extract in classic and integrated modes with the following limitations.
1.Materialized views created WITH ROWID are not supported.
2.The materialized view log can be created WITH ROWID.
3.The source table must have a primary key.
4.Truncates of materialized views are not supported. You can use a DELETE FROM statement.
5.DML (but not DDL) from a full refresh of a materialized view is supported. If DDL support for this feature is required, open an Oracle GoldenGate support case.
6.For Replicat the Create MV command must include the FOR UPDATE clause
7.Either materialized views can be replicated or the underlying base table(s), but not both.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26474945/viewspace-1681018/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Oracle、Mysql 专业技术服务（兼职）
- Tidb 运维--集群视图的使用
- Oracle 如何快速的 duplicate 一个数据库
- Exadata修改sshd密码验证方式 延迟10分钟关闭 明明密码对了却登录不上
- Oracle RAC 第二节点打补丁报错 oui-patch.xml (Permission denied)
- oracle database link (dblink) 工作原理
- rpm包 手工安装OEM 12c agent
- 安装 OEM 报错 Error in invoking target 'install' of makefile
- oem12c opatchauto failed with error code 135
- 创建四节点 RAC 启动时报错 ORA-01618: redo thread 4 is not enabled - cannot mount
