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.KU$_TABLESPACE_VIEW

Object Details

Object Name:	KU$_TABLESPACE_VIEW
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
VERS_MAJOR	CHAR	(1)
VERS_MINOR	CHAR	(1)
TS_NUM	NUMBER
NAME	VARCHAR2	(30)
OWNER_NUM	NUMBER
STATUS	NUMBER
CONTENTS	NUMBER
UNDOFILE_NUM	NUMBER
UNDOBLOCK_NUM	NUMBER
BLOCKSIZE	NUMBER
INC_NUM	NUMBER
SCNWRP	NUMBER
SCNBAS	NUMBER
DFLMINEXT	NUMBER
DFLMAXEXT	NUMBER
DFLINIT	NUMBER
DFLINCR	NUMBER
DFLMINLEN	NUMBER
DFLEXTPCT	NUMBER
DFLOGGING	NUMBER
AFFSTRENGTH	NUMBER
BITMAPPED	NUMBER
PLUGGED	NUMBER
DIRECTALLOWED	NUMBER
FLAGS	NUMBER
PITRSCNWRP	NUMBER
PITRSCNBAS	NUMBER
OWNERINSTANCE	VARCHAR2	(30)
BACKUPOWNER	VARCHAR2	(30)
GROUPNAME	VARCHAR2	(30)
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	VARCHAR2	(1000)
SPARE4	VARCHAR2	(19)
FILESPEC	KU$_FILE_LIST_T	(64)
ENCRYPTIONALG	VARCHAR2	(7)

Query Text

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


SELECT VERS_MAJOR
,      VERS_MINOR
,      TS_NUM
,      NAME
,      OWNER_NUM
,      STATUS
,      CONTENTS
,      UNDOFILE_NUM
,      UNDOBLOCK_NUM
,      BLOCKSIZE
,      INC_NUM
,      SCNWRP
,      SCNBAS
,      DFLMINEXT
,      DFLMAXEXT
,      DFLINIT
,      DFLINCR
,      DFLMINLEN
,      DFLEXTPCT
,      DFLOGGING
,      AFFSTRENGTH
,      BITMAPPED
,      PLUGGED
,      DIRECTALLOWED
,      FLAGS
,      PITRSCNWRP
,      PITRSCNBAS
,      OWNERINSTANCE
,      BACKUPOWNER
,      GROUPNAME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      FILESPEC
,      ENCRYPTIONALG
FROM SYS.KU$_TABLESPACE_VIEW;

Dependencies

[top of page]

SYS.KU$_TABLESPACE_VIEW references the following:

SYS: DBMS_METADATA - show dependent code; DBMS_METADATA_UTIL - show dependent code; KU$_FILE_LIST_T; KU$_FILE_VIEW; KU$_TABLESPACE_T; SESSION_ROLES; STANDARD - show dependent code; TS$

SYS.KU$_TABLESPACE_VIEW is referenced by following:

SYS: DBMS_METADATA - show dependent code; KU$_PLUGTS_TABLESPACE_VIEW; KU$_ROLLBACK_VIEW