Snapshot creation problem

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 17 Nov 1999 20:23:27 GMT
Message-ID: <38330e95.90208128@news.earthlink.net>

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

Received on Wed Nov 17 1999 - 14:23:27 CST