Insufficient privilages creating a SNAPSHOT

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 15 Nov 1999 17:24:01 GMT
Message-ID: <38304166.9577418@news.earthlink.net>

SQLWKS> create snapshot player 
     2> tablespace swfootballdat
     3> storage (INITIAL 100K NEXT 50K)
     4> using INDEX tablespace swfootballind
     5> REFRESH FAST
     6> AS
     7> SELECT * FROM PLAYER_at_swfootball_link
     8> 
SELECT * FROM PLAYER_at_swfootball_link
       *

ORA-01031: insufficient privileges

Any ideas?
Create table as select * from player_at_swfootbal_link works.

Thanx

---

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

Received on Mon Nov 15 1999 - 11:24:01 CST