ablog

不器用で落着きのない技術者のメモ

ORA-01950: no privileges on tablespace ...

$ sqlplus / as sysdba
SQL> create table scott.test_users (id number(4)) tablespace users;
create table scott.test_users (id number(4)) tablespace users
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'

SQL>  alter user scott quota  unlimited on users;

User altered.

SQL> create table scott.test_users (id number(4)) tablespace users;

Table created.