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

VIEW: SYS.EXU81IXCP

Object Details
Object Name: EXU81IXCP
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

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
FROM SYS.EXU81IXCP;

Dependencies

[top of page]

SYS.EXU81IXCP references the following:

SchemaSYS
ViewEXU9IXCP
TableTS$
SYS.EXU81IXCP is referenced by following:

SchemaSYS
ViewEXU81IXCPU