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


TABLE: SYS.FIXED_OBJ$

Object Details
Object Name: FIXED_OBJ$
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_FIXED_OBJ$_OBJ# NORMAL UNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
TIMESTAMP DATE
Yes
FLAGS NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 VARCHAR2 (1000)
SPARE5 VARCHAR2 (1000)
SPARE6 DATE

Query Text

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


SELECT OBJ#
,      TIMESTAMP
,      FLAGS
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
FROM SYS.FIXED_OBJ$;

Dependencies

[top of page]

SYS.FIXED_OBJ$ does not reference any database object

SYS.FIXED_OBJ$ is referenced by following:

SchemaSYS
ViewALL_TAB_COL_STATISTICS
ViewALL_TAB_HISTOGRAMS
ViewALL_TAB_STATISTICS
ViewDBA_TAB_COL_STATISTICS
ViewDBA_TAB_HISTOGRAMS
ViewDBA_TAB_STATISTICS
Package BodyDBMS_STATS_INTERNAL - show dependent code
ViewUSER_TAB_COL_STATISTICS
ViewUSER_TAB_HISTOGRAMS
ViewUSER_TAB_STATISTICS
View_user_stat