Re: Create materialized views

you're not showing the statement..

u need to give explicit privs to create snapshots (mat. views), afaik

On Thu, 8 Nov 2001 15:16:29 -0800, "Peter Shvets" <pshvets_at_powermarket.com> wrote:

>Hello everybody on this group.
>We are getting a weird error when try to run a few SQL scripts for creating
>materialized views as batch.
>So we have a SQL script with something like following:
>******************
> set echo on
>prompt mv1
> @mv1;
>
>prompt mv2
> @mv2;
>
>prompt mv3
> @mv3;
>...
>...
>...
>end of file
>********************
>mv2 uses mv1 in the FROM clause.
>The problem is that mv2 creation fails every time with the following error:
>
> ORA-01031: insufficient privileges
> ORA-00942: table or view does not exist
>If the same script, mv2.sql run again it succeeds.
>As a temporary solution we run this script twice:
>******************
> set echo on
>prompt mv1
> @mv1;
>
>prompt mv2
> @mv2;
>@mv2;
>
>prompt mv3
> @mv3;
>...
>...
>...
>end of file
>********************
>Any hints? Ideas?
>Please help!
>Thank you in advance!
>
>Peter.
>
>

.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email