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 ***