sys@ORCL> create view emrep as select * from hr.employees;View created.sys@ORCL> create materialized view mv_emrep refresh force on commit as select * from emrep; create materialized view mv_emrep refresh force on commit as select * from emrep * ERROR at line 1: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view sys@ORCL> !oerr ora 12054 12054, 00000, "cannot set the ON COMMIT refresh attribute for the materialized view" // *Cause: The materialized view did not satisfy conditions for refresh at // commit time. // *Action: Specify only valid options.
sys@ORCL> create materialized view mv_emrep refresh force on demand as select * from emrep;Materialized view created.
create materialized view mv_emrep refresh force on commit as select * from emrep
*
ERROR at line 1:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
sys@ORCL> !oerr ora 12054
12054, 00000, "cannot set the ON COMMIT refresh attribute for the materialized view"
// *Cause: The materialized view did not satisfy conditions for refresh at
// commit time.
// *Action: Specify only valid options.