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

VIEW: SYS.EXU8TBP

Object Details
Object Name: EXU8TBP
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
PNAME VARCHAR2 (128)
PROWCNT NUMBER

PBLKCNT NUMBER

PAVGRLEN NUMBER

PFLAGS NUMBER
Yes
PARTNO NUMBER
Yes
HIBOUNDLEN NUMBER
Yes
HIBOUNDVAL LONG (0)
TSNAME VARCHAR2 (30) Yes
TSNO NUMBER

FILENO NUMBER

BLOCKNO NUMBER

PCTFREE$ NUMBER

PCTUSED$ NUMBER
Yes
INITRANS NUMBER
Yes
MAXTRANS NUMBER
Yes
DEFLOG NUMBER

TSDEFLOG NUMBER
Yes
BLEVEL NUMBER

LEAFCNT NUMBER

DISTKEY NUMBER

LBLKKEY NUMBER

DBLKKEY NUMBER

CLUFAC NUMBER

IFLAGS NUMBER

Query Text

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


SELECT OBJID
,      DOBJID
,      BOBJID
,      OWNERID
,      PNAME
,      PROWCNT
,      PBLKCNT
,      PAVGRLEN
,      PFLAGS
,      PARTNO
,      HIBOUNDLEN
,      HIBOUNDVAL
,      TSNAME
,      TSNO
,      FILENO
,      BLOCKNO
,      PCTFREE$
,      PCTUSED$
,      INITRANS
,      MAXTRANS
,      DEFLOG
,      TSDEFLOG
,      BLEVEL
,      LEAFCNT
,      DISTKEY
,      LBLKKEY
,      DBLKKEY
,      CLUFAC
,      IFLAGS
FROM SYS.EXU8TBP;

Dependencies

[top of page]

SYS.EXU8TBP references the following:

SchemaSYS
TableOBJ$
TableTABPART$
TableTS$
SYS.EXU8TBP is referenced by following:

SchemaSYS
ViewEXU8TBPU