DBA_TS_QUOTAS
DBA_TS_QUOTASの仕様
SQL> desc dba_ts_quotas
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 USERNAME                                  NOT NULL VARCHAR2(30)
 BYTES                                              NUMBER
 MAX_BYTES                                          NUMBER
 BLOCKS                                             NUMBER
 MAX_BLOCKS                                         NUMBER
 DROPPED                                            VARCHAR2(3)
 
SQL>

MAX_BYTES:ユーザーの割当て制限(バイト)。無制限の場合は-1。
MAX_BLOCKS:ユーザーの割当て制限(Oracleブロック単位)。無制限の場合は-1。
使用例
SQL> select * from dba_ts_quotas;
 
TABLESPACE_NAME                USERNAME                            BYTES  MAX_BYTES     BLOCKS MAX_BLOCKS DRO
------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---
USERS                          TOM                                     0         -1          0         -1 NO
USERS                          JASON                                   0 1073741824          0     262144 NO
 
SQL>
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License