Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insufficient privilages creating a SNAPSHOT
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