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

VIEW: SYS.EXU9TBCP

Object Details
Object Name: EXU9TBCP
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
Yes
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.EXU9TBCP;

Dependencies

[top of page]

SYS.EXU9TBCP references the following:

SchemaSYS
TableOBJ$
TableTABCOMPART$
TableTS$
SYS.EXU9TBCP is referenced by following:

SchemaSYS
ViewEXU81TBCP
ViewEXU9TBCPU