DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_TS_QUOTAS

Object Details
Object Name: DBA_TS_QUOTAS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Tablespace quotas for all users

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLESPACE_NAME VARCHAR2 (30) Yes Tablespace name
USERNAME VARCHAR2 (128) Yes User with resource rights on the tablespace
BYTES NUMBER

Number of bytes charged to the user
MAX_BYTES NUMBER

User's quota in bytes. NULL if no limit
BLOCKS NUMBER

Number of ORACLE blocks charged to the user
MAX_BLOCKS NUMBER

User's quota in ORACLE blocks. NULL if no limit
DROPPED VARCHAR2 (3)
Whether the tablespace has been dropped
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TABLESPACE_NAME
,      USERNAME
,      BYTES
,      MAX_BYTES
,      BLOCKS
,      MAX_BLOCKS
,      DROPPED
FROM SYS.DBA_TS_QUOTAS;

Dependencies

[top of page]

SYS.DBA_TS_QUOTAS references the following:

SchemaSYS
PL/SQL PackageDBMS_SPACE_ADMIN - show dependent code
ViewTBS_SPACE_USAGE
TableTS$
TableUSER$
SYS.DBA_TS_QUOTAS is referenced by following:

SchemaPUBLIC
SynonymDBA_TS_QUOTAS
SchemaSYS
Package BodyDBMS_DBFS_SFS_ADMIN - show dependent code
Package BodyDBMS_SPACE - show dependent code