ORA-12066: invalid CREATE MATERIALIZED VIEW command

ORA-12066: invalid CREATE MATERIALIZED VIEW command


Cause:


The Replication API does not support the following options and types of materialized view:
* ROWID materialized views
* REFRESH ON COMMIT
* ON PREBUILT TABLE
* BUILD DEFERRED
* NEVER REFRESH
* ENABLE QUERY REWRITE



Action:


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