Hi,
I am getting the following error while creating the view....
SQL > Create materialized mv_prod
2 refresh fast on commit
3 as select *from products;
Create materialized mv_prod
*
ERROR at line 1:
ORA-00905 (See ORA-00905.ora-code.com): missing keyword
SQL > Create materialized view mv_prod
2 refresh fast on commit
3 as select *from products;
as select *from products
*
ERROR at line 3:
ORA-12054 (See ORA-12054.ora-code.com): cannot set the ON COMMIT refresh attribute for the materialized view
