=20
create materialized view mv_prod
refresh fast
as select * from products;
-- --Original Message-- --
From: oracle-l-bounce@(protected) =
[mailto:oracle-l-bounce@(protected)] On Behalf Of Srinivas T
Sent: Monday, October 11, 2004 3:50 AM
To: oracle-l@(protected)
Subject: Materialized view
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
