创建用户限额
create user itme
identified by zero
default tablespace myspace
quota 10M on myspace
quota 5M on system
temporary tablespace temp
profile default
account unlock;
修改用户限额
alter user itme quota 50M on users;
查看用户的表空间限额
SQL> select * from dba_ts_quotas;
TABLESPACE_NAME USERNAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS DRO
------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---
SYSAUX OLAPSYS 3801088 -1 464 -1 NO
SYSAUX SYSMAN 48824320 -1 5960 -1 NO
SYSAUX FLOWS_FILES 0 -1 0 -1 NO
SYSAUX APPQOSSYS 0 -1 0 -1 NO
MAX_BYTES=-1表示无限制使用表空间