Materialized View 2004-10-11 - By Srinivas T
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
Advice ...
ThanX in advance.
srinivas
--
http://www.freelists.org/webpage/oracle-l
|
|
