Re: error creating materialized view

On Thu, 20 Oct 2005 16:27:38 -0400, JS interested us by writing:

> 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;
> /

...
> What am I missing?

A 1 second glance at http://docs.oracle.com in the Oracle SQL Reference manual under 'CREATE MATERIALIZED VIEW' indicates that the 'OR REPLACE' syntax is not valid. (However, looking at 'CREATE PACKAGE' I find it does specify the 'OR REPLACE' is valid but optional.)

Perhaps it's your syntax?

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***