Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Insufficient privilages creating a SNAPSHOT

Re: Insufficient privilages creating a SNAPSHOT

From: <yewpc_at_my-deja.com>
Date: Tue, 16 Nov 1999 02:58:46 GMT
Message-ID: <80qh94$46d$1@nnrp1.deja.com>


Just try to grant create snapshot and create trigger to the creater.

In article <38304166.9577418_at_news.earthlink.net>,   andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 15 1999 - 20:58:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US