Re: error creating materialized view

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 20 Oct 2005 22:36:44 +0200
Message-ID: <dj8v4r$s33$00$1@news.t-online.com>

JS schrieb:
> Hi,
>
> I am trying to tune a materialized view with following command
>
> var viewid varchar2(20);
> begin
> dbms_advisor.tune_mview
> (:viewid, 'create or replace materialized view employeeView refresh fast
> enable query rewrite as select firstname from employees');
> end;
> /
>
> But I get this error
>
> ERROR at line 1:
> ORA-20000: Invalid CREATE MATERIALIZED VIEW statement because of:
> ORA-00905: missing keyword
>
> What am I missing?
>
> Thanks

May be materialized views can not be "replaced" ?

Best regards

Maxim Received on Thu Oct 20 2005 - 15:36:44 CDT