eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_TS_QUOTAS

Object Details

Object Name:	USER_TS_QUOTAS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Tablespace quotas for the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TABLESPACE_NAME	VARCHAR2	(30)	Yes	Tablespace name
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
,      BYTES
,      MAX_BYTES
,      BLOCKS
,      MAX_BLOCKS
,      DROPPED
FROM SYS.USER_TS_QUOTAS;

Dependencies

[top of page]

SYS.USER_TS_QUOTAS references the following:

SYS: DBMS_SPACE_ADMIN - show dependent code; TBS_SPACE_USAGE; TS$

SYS.USER_TS_QUOTAS is referenced by following:

PUBLIC: USER_TS_QUOTAS