DBA_TS_QUOTAS

6.58 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(128)`	`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`		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