Re: Snapshot creation problem

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 18 Nov 1999 19:01:08 +0800
Message-ID: <3833DC74.25A8@yahoo.com>

NetComrade wrote:
>
> SQL> CREATE SNAPSHOT player
> PCTFREE 30 PCTUSED 50 TABLESPACE swhoopsdat
> 2 STORAGE (INITIAL 100M NEXT 50M PCTINCREASE 0)
> USING INDEX TABLESPACE swhoopsind
> STORAGE (INITIAL 50M NEXT 25M)
> REFRESH FAST
> WITH ROWID
> AS
> SELECT * FROM player_at_hoop.world; 3 4 5 6 7 8 9
> SELECT * FROM player_at_hoop.world
> *
> ERROR at line 9:
> ORA-12018: following error encountered during code generation for
> "SWHOOPS"."PLAYER"
> ORA-00942: table or view does not exist
> ORA-02063: preceding line from HOOP.WORLD
>
> SQL> create table player as select * from player_at_hoop.world;
>
> Table created.
>
> we
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email

try your select after running

SQL> set role none

and see if that is the problem (roles are not enabled during pl/sql execution)
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Nov 18 1999 - 05:01:08 CST