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@(protected) > 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 (See ORA-00905.ora-code.com): 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 (See ORA-12054.ora-code.com): 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
