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

VIEW: SYS.EXU9IXCP

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJID NUMBER
Yes
DOBJID NUMBER

BOBJID NUMBER
Yes
OWNERID NUMBER
Yes
COMPNAME VARCHAR2 (128)
PARTNO NUMBER
Yes
HIBOUNDLEN NUMBER
Yes
HIBOUNDVAL LONG (0)
PROWCNT NUMBER

PBLKCNT NUMBER

PAVGRLEN NUMBER

TSNAME VARCHAR2 (30)
PCTFREE$ NUMBER

PCTUSED$ NUMBER

INITRANS NUMBER
Yes
MAXTRANS NUMBER
Yes
INIEXTS NUMBER

EXTSIZE NUMBER

MINEXTS NUMBER

MAXEXTS NUMBER

EXTPCT NUMBER

FLISTS NUMBER

FREEGRP NUMBER

PCACHE VARCHAR2 (7)
DEFLOG NUMBER

TSDEFLOG NUMBER

BLEVEL NUMBER

LEAFCNT NUMBER

DISTKEY NUMBER

LBLKKEY NUMBER

DBLKKEY NUMBER

CLUFAC NUMBER

BLOCKSIZE NUMBER

HSCOMPRESS NUMBER

MAXSIZE NUMBER

PFLAGS NUMBER
Yes
Query Text

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


SELECT OBJID
,      DOBJID
,      BOBJID
,      OWNERID
,      COMPNAME
,      PARTNO
,      HIBOUNDLEN
,      HIBOUNDVAL
,      PROWCNT
,      PBLKCNT
,      PAVGRLEN
,      TSNAME
,      PCTFREE$
,      PCTUSED$
,      INITRANS
,      MAXTRANS
,      INIEXTS
,      EXTSIZE
,      MINEXTS
,      MAXEXTS
,      EXTPCT
,      FLISTS
,      FREEGRP
,      PCACHE
,      DEFLOG
,      TSDEFLOG
,      BLEVEL
,      LEAFCNT
,      DISTKEY
,      LBLKKEY
,      DBLKKEY
,      CLUFAC
,      BLOCKSIZE
,      HSCOMPRESS
,      MAXSIZE
,      PFLAGS
FROM SYS.EXU9IXCP;

Dependencies

[top of page]

SYS.EXU9IXCP references the following:

SchemaSYS
TableIND$
TableINDCOMPART$
TableOBJ$
TableTS$
SYS.EXU9IXCP is referenced by following:

SchemaSYS
ViewEXU81IXCP
ViewEXU9IXCPU