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

VIEW: SYS.EXU8NTB

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
POBJID NUMBER
Yes
OBJID NUMBER
Yes
NAME VARCHAR2 (128) Yes
DOBJID NUMBER

OWNER VARCHAR2 (128) Yes
OWNERID NUMBER
Yes
TABLESPACE VARCHAR2 (30) Yes
TSNO NUMBER
Yes
FILENO NUMBER
Yes
BLOCKNO NUMBER
Yes
AUDIT$ VARCHAR2 (38) Yes
COMMENT$ VARCHAR2 (4000)
CLUSTERFLAG NUMBER

MTIME DATE
Yes
MODIFIED NUMBER

PCTFREE$ NUMBER

PCTUSED$ NUMBER
Yes
INITRANS NUMBER
Yes
MAXTRANS NUMBER
Yes
DEGREE NUMBER

INSTANCES NUMBER

CACHE NUMBER

TEMPFLAGS NUMBER

PROPERTY NUMBER
Yes
DEFLOG NUMBER

TSDEFLOG NUMBER
Yes
ROID RAW (16)
COLPROP NUMBER
Yes
EXPNAME VARCHAR2 (4000)
ROWCNT NUMBER

BLKCNT NUMBER

AVGRLEN NUMBER

TFLAGS NUMBER
Yes
NTCOLFLGS NUMBER

INTCOLID NUMBER
Yes
OBJSTATUS NUMBER
Yes
COLTYPE NUMBER
Yes
Query Text

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


SELECT POBJID
,      OBJID
,      NAME
,      DOBJID
,      OWNER
,      OWNERID
,      TABLESPACE
,      TSNO
,      FILENO
,      BLOCKNO
,      AUDIT$
,      COMMENT$
,      CLUSTERFLAG
,      MTIME
,      MODIFIED
,      PCTFREE$
,      PCTUSED$
,      INITRANS
,      MAXTRANS
,      DEGREE
,      INSTANCES
,      CACHE
,      TEMPFLAGS
,      PROPERTY
,      DEFLOG
,      TSDEFLOG
,      ROID
,      COLPROP
,      EXPNAME
,      ROWCNT
,      BLKCNT
,      AVGRLEN
,      TFLAGS
,      NTCOLFLGS
,      INTCOLID
,      OBJSTATUS
,      COLTYPE
FROM SYS.EXU8NTB;

Dependencies

[top of page]

SYS.EXU8NTB references the following:

SchemaSYS
TableATTRCOL$
TableCOL$
TableCOLTYPE$
TableCOM$
TableNTAB$
TableOBJ$
TableTAB$
TableTS$
TableUSER$
SYS.EXU8NTB is referenced by following:

SchemaSYS
ViewEXU8NTBU