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: Jared Still <jkstill_at_gmail.com>
Date: Mon, 11 Oct 2004 17:19:33 +0100
Message-ID: <bf4638041011091958bafcf@mail.gmail.com>


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

Original text of this message

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