HansF wrote:
> 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?
>
Now I get
ORA-20000: Invalid CREATE MATERIALIZED VIEW statement because of:
ORA-00942: table or view does not exist
Received on Fri Oct 21 2005 - 13:40:13 CDT
