RE: Materialized view
- From: "Parker, Matthew" <matthewp@xxxxxxxxxx>
- To: <SrinivasT@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Oct 2004 04:08:14 -0700
=20
create materialized view mv_prod
refresh fast
as select * from products;
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Srinivas T
Sent: Monday, October 11, 2004 3:50 AM
To: oracle-l@xxxxxxxxxxxxx
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: 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: cannot set the ON COMMIT refresh attribute for the =
materialized view
Advice ...
ThanX in advance.
srinivas
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
