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

TABLE: SYS.UNDOHIST$

Object Details
Object Name: UNDOHIST$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_UNDOHIST1 NORMAL UNIQUE TablespaceSYSTEM ColumnUS#
ColumnINC#
Columns
Name Datatype Length Mandatory Comments
US# NUMBER
Yes
INC# NUMBER
Yes
TSN NUMBER
Yes
FILE# NUMBER
Yes
BLOCK# NUMBER
Yes
CRSCNWRP NUMBER
Yes
CRSCNBAS NUMBER
Yes
DRSCNWRP NUMBER
Yes
DRSCNBAS NUMBER
Yes
CRTTIME NUMBER
Yes
DRPTIME NUMBER
Yes
NAME VARCHAR2 (30) Yes
USER# NUMBER
Yes
SCNWRP NUMBER

SCNBAS NUMBER

XACTSQN NUMBER

UNDOSQN NUMBER

INST# NUMBER

FLAGS1 NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 NUMBER

SPARE5 NUMBER

SPARE6 NUMBER

SPARE7 NUMBER

SPARE8 NUMBER

Query Text

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


SELECT US#
,      INC#
,      TSN
,      FILE#
,      BLOCK#
,      CRSCNWRP
,      CRSCNBAS
,      DRSCNWRP
,      DRSCNBAS
,      CRTTIME
,      DRPTIME
,      NAME
,      USER#
,      SCNWRP
,      SCNBAS
,      XACTSQN
,      UNDOSQN
,      INST#
,      FLAGS1
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SPARE8
FROM SYS.UNDOHIST$;

Dependencies

[top of page]

SYS.UNDOHIST$ does not reference any database object

SYS.UNDOHIST$ is not referenced by any database object