Re: Materialized view
- From: Jared Still <jkstill@xxxxxxxxx>
- To: srinivast@xxxxxxxxxxxxxxx
- Date: Mon, 11 Oct 2004 17:19:33 +0100
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@xxxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
