Re: beginner question , ora-1950

From: <satar_at_my-dejanews.com>
Date: Tue, 20 Oct 1998 19:01:33 GMT
Message-ID: <70imme$42e$1@nnrp1.dejanews.com>

start off with something like...
ALTER USER "SCOTT" QUOTA 10 M ON USER_DATA; Then as the need arises, increase the quota.. ALTER USER "SCOTT" QUOTA 20 M ON USER_DATA; Hope this helps,
Satar Naghshineh
In article <362a0030.145262_at_news.dj.net.tw>, chishin_at_m2.dj.net.tw (¤p·s) wrote:
> hi all:
> user SCOTT have create table privilege, and default tablespace is
> USER_DATA, but when create table by using SQL*PLUS
> it show
>
> ORA-01950: no privileges on tablespace 'USER_DATA'
>
> and the manual say user must have quota or have unlimited tablespace
> but have unlimited tablespace privilege is dangerous, and set quota
> may change many time , is there someway to do so, and not use that two
> way , thanks
>
> any suggestion is welcome
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 14:01:33 CDT