重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-12066: invalid CREATE MATERIALIZED VIEW command [打印本页]

---

作者: admin    时间: 2016-8-5 10:06
标题: ORA-12066: invalid CREATE MATERIALIZED VIEW command
ORA-12066: invalid CREATE MATERIALIZED VIEW command
Cause: The Replication APIdoes not support the following options and types of
materialized view:
o ROWID materialized views
o REFRESH ON COMMIT
o ON PREBUILT TABLE
o BUILD DEFERRED
o NEVER REFRESH
o ENABLE QUERY REWRITE
Action: Create a PRIMARY KEYmaterialized view using REFRESH WITH
PRIMARY KEY and/or remove the invalid options.

---

欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2