Tag Archives: ORA-12066

ORA-12066: invalid CREATE MATERIALIZED VIEW command

oracle

ORA-12066: invalid CREATE MATERIALIZED VIEW command
Cause: The Replication API does 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 KEY materialized view using REFRESH WITH PRIMARY KEY and/or remove the invalid options.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/