Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Materialized view

RE: Materialized view

From: Parker, Matthew <matthewp_at_amazon.com>
Date: Mon, 11 Oct 2004 04:08:14 -0700
Message-ID: <F385925F530F6C4081F1659F71640EB3AD0F82@ex-mail-sea-04.ant.amazon.com>


=20
create materialized view mv_prod
refresh fast
as select * from products;

-----Original Message-----

From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Srinivas T Sent: Monday, October 11, 2004 3:50 AM
To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 11 2004 - 06:03:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US