beginner question , ora-1950

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 Received on Sun Oct 18 1998 - 09:59:41 CDT