eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.EXU9TABS

Object Details

Object Name:	EXU9TABS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
OBJID	NUMBER
DOBJID	NUMBER
NAME	VARCHAR2	(128)
OWNER	VARCHAR2	(128)
OWNERID	NUMBER
TABLESPACE	VARCHAR2	(30)
TSNO	NUMBER
FILENO	NUMBER
BLOCKNO	NUMBER
AUDIT$	VARCHAR2	(38)
COMMENT$	VARCHAR2	(4000)
CLUSTERFLAG	NUMBER
MTIME	DATE
MODIFIED	NUMBER
TABNO	NUMBER
PCTFREE$	NUMBER
PCTUSED$	NUMBER
INITRANS	NUMBER
MAXTRANS	NUMBER
DEGREE	NUMBER
INSTANCES	NUMBER
CACHE	NUMBER
TEMPFLAGS	NUMBER
PROPERTY	NUMBER
DEFLOG	NUMBER
TSDEFLOG	NUMBER
ROID	RAW	(16)
RECPBLK	NUMBER
SECONDARYOBJ	NUMBER
ROWCNT	NUMBER
BLKCNT	NUMBER
AVGRLEN	NUMBER
TFLAGS	NUMBER
TRIGFLAG	NUMBER
OBJSTATUS	NUMBER
XDBOOL	NUMBER

Query Text

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


SELECT OBJID
,      DOBJID
,      NAME
,      OWNER
,      OWNERID
,      TABLESPACE
,      TSNO
,      FILENO
,      BLOCKNO
,      AUDIT$
,      COMMENT$
,      CLUSTERFLAG
,      MTIME
,      MODIFIED
,      TABNO
,      PCTFREE$
,      PCTUSED$
,      INITRANS
,      MAXTRANS
,      DEGREE
,      INSTANCES
,      CACHE
,      TEMPFLAGS
,      PROPERTY
,      DEFLOG
,      TSDEFLOG
,      ROID
,      RECPBLK
,      SECONDARYOBJ
,      ROWCNT
,      BLKCNT
,      AVGRLEN
,      TFLAGS
,      TRIGFLAG
,      OBJSTATUS
,      XDBOOL
FROM SYS.EXU9TABS;

Dependencies

[top of page]

SYS.EXU9TABS references the following:

SYS: COL$; EXU10TABS

SYS.EXU9TABS is referenced by following:

SYS: EXU81TABS; EXU9TAB; EXU9TABSU