In case you miss the point of Matthew's post, you are
missing a space between '*' and 'from'
On Mon, 11 Oct 2004 16:19:42 +0530, Srinivas T
<srinivast_at_kpitcummins.com> wrote:
> 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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 11 2004 - 11:15:23 CDT
