Materialized view

From: Srinivas T <SrinivasT_at_KPITCummins.com>
Date: Mon, 11 Oct 2004 16:19:42 +0530
Message-ID: <4A1BE23A7B777442B60F4B4916AE0F130292FE39@sohm.kpit.com>

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

Received on Mon Oct 11 2004 - 05:51:46 CDT