ORA-01536

SQL> create table emp3 rowdependencies as select * from emp;
create table emp3 rowdependencies as select * from emp
                                                   *
ERROR at line 1:
ORA-01536: space quota exceeded for tablespace 'USERS'


SQL> show user
USER is "SCOTT"
SQL> conn / as sysdba
Connected.
SQL> alter user scott quota unlimited on users;

User altered.

SQL> conn scott/oracle
Connected.
SQL> create table emp3 rowdependencies as select * from emp;

Table created. 

SQL> r
  1* SELECT * FROM Dba_Ts_Quotas

TABLESPACE USERNAME        BYTES  MAX_BYTES     BLOCKS MAX_BLOCKS DRO
---------- ---------- ---------- ---------- ---------- ---------- ---
USERS      SCOTT       197394432         -1      24096         -1 NO
SYSAUX     APPQOSSYS           0         -1          0         -1 NO
SYSAUX     FLOWS_FILE          0         -1          0         -1 NO
           S

TBS_GGUSER OGG          52559872         -1       6416         -1 NO
SYSAUX     OLAPSYS       7667712         -1        936         -1 NO
SYSAUX     SYSMAN       14024704         -1       1712         -1 NO

6 rows selected.

max_bytes字段就是了 
-1是代表没有限制,其它值多少就是多少了. 

不对用户做表空间限额控制: 
GRANT UNLIMITED TABLESPACE TO ***(用户); 
这种方式是全局性的. 
或者 
alter user ***(用户名) quota unlimited on ***(表空间); 
这种方式是针对特定的表空间的. 

可以分配自然也可以回收了: 
revoke unlimited tablespace from ***(用户) 
或者 
alter user *** quota 0 on ***

 

请使用浏览器的分享功能分享到微信等