Re: Oracle 8.1.7 problem creating simple materialized view

From: Jack <amitkr.3_at_gmail.com>
Date: 7 Mar 2006 07:06:24 -0800
Message-ID: <1141743984.108757.31570@e56g2000cwe.googlegroups.com>

frank.van.bortel_at_gmail.com wrote:
> Try the same select (not the create snapshot) statement after you
> issued:
> set role none
>
> Does it still react as expected? Then your grants are not the issue.
Thanks ..

SQL> set role none;

Role set.

Select * from thresholds_ak_at_ak_test .... AS Expected

SQL> CREATE MATERIALIZED VIEW thresholds_ak 2 as
3 SELECT * FROM thresholds_ak_at_ak_test;

OUTPUTS: SELECT * FROM op_leave_thresholds_at_rmop

*
ERROR at line 3:

ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 919
ORA-06512: at line 1

Thanks Received on Tue Mar 07 2006 - 09:06:24 CST