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

VIEW: SYS.EXU9PDS

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJID NUMBER
Yes
TYPE NUMBER
Yes
OWNERID NUMBER
Yes
PTYPE NUMBER
Yes
SUBPTYPE NUMBER

PFLAG NUMBER

PCNT NUMBER
Yes
PKCNT NUMBER
Yes
PCTFREE$ NUMBER

PCTUSED$ NUMBER
Yes
INITRANS NUMBER
Yes
MAXTRANS NUMBER
Yes
INIEXTS NUMBER

EXTSIZE NUMBER

MINEXTS NUMBER

MAXEXTS NUMBER

EXTPCT NUMBER

FLISTS NUMBER
Yes
FREEGRP NUMBER
Yes
TSNAME VARCHAR2 (30)
DEFLOG NUMBER
Yes
PCACHE VARCHAR2 (7)
BLOCKSIZE NUMBER

HSCOMPRESS NUMBER

DEFSUBPCNT NUMBER

MAXSIZE NUMBER

Query Text

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


SELECT OBJID
,      TYPE
,      OWNERID
,      PTYPE
,      SUBPTYPE
,      PFLAG
,      PCNT
,      PKCNT
,      PCTFREE$
,      PCTUSED$
,      INITRANS
,      MAXTRANS
,      INIEXTS
,      EXTSIZE
,      MINEXTS
,      MAXEXTS
,      EXTPCT
,      FLISTS
,      FREEGRP
,      TSNAME
,      DEFLOG
,      PCACHE
,      BLOCKSIZE
,      HSCOMPRESS
,      DEFSUBPCNT
,      MAXSIZE
FROM SYS.EXU9PDS;

Dependencies

[top of page]

SYS.EXU9PDS references the following:

SchemaSYS
TableOBJ$
TablePARTOBJ$
TableTS$
SYS.EXU9PDS is referenced by following:

SchemaSYS
ViewEXU8PDS
ViewEXU9PDSU