Static Data Dictionary Views, 250 of 452

DBA_TS_QUOTAS

DBA_TS_QUOTAS describes tablespace quotas for all users.

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.