oracle创建用户使用表空间限额，修改，查询

创建用户限额

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表示无限制使用表空间