Oracle Solution for Error ora-12066

ORA-12066: invalid CREATE MATERIALIZED VIEW command

What triggered the Error:

The Replication API does not support the following options and types of materialized view: *o ROWID materialized view. *o REFRESH ON COMMI. *o ON PREBUILT TABL. *o BUILD DEFERRE. *o NEVER REFRES. *o ENABLE QUERY REWRIT.

What should we do to fix it:

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