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 viewso REFRESH ON COMMITo ON PREBUILT TABLEo BUILD DEFERREDo NEVER REFRESHo ENABLE QUERY REWRITE

Action: Create a PRIMARY KEY materialized view using REFRESH WITH PRIMARY KEY and/or remove the invalid options.

Error Type: ORA

• Additional information for ORA-12066: invalid CREATE MATERIALIZED VIEW command12066
Discussions and solutions for Oracle Database Error ORA-12066: invalid CREATE MATERIALIZED VIEW command Developer anwers for Oracle Database Error ORA-12066: invalid CREATE MATERIALIZED VIEW command FAQs for ORA-12066: invalid CREATE MATERIALIZED VIEW command search others tips for ORA-12066: invalid CREATE MATERIALIZED VIEW command