../E40402-16.epub /> ../E40402-16.mobi />

DBA_TS_QUOTAS

DBA_TS_QUOTAS describes tablespace quotas for all users.

Related View

USER_TS_QUOTAS describes tablespace quotas for the current user. This view does not display the USERNAME column.

Column Datatype NULL Description
TABLESPACE_NAME VARCHAR2(30) NOT NULL Tablespace name
USERNAME VARCHAR2(30) NOT NULL User with resource rights on the tablespace
BYTES NUMBER   Number of bytes charged to the user
MAX_BYTES NUMBER   User's quota in bytes, or -1 if no limit
BLOCKS NUMBER NOT NULL Number of Oracle blocks charged to the user
MAX_BLOCKS NUMBER   User's quota in Oracle blocks, or -1 if no limit
DROPPED VARCHAR2(3)   Whether the tablespace has been dropped