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

TABLE: SYS.SUMDETAIL$

Object Details
Object Name: SUMDETAIL$
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_SUMDETAIL$_1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnSUMOBJ#
I_SUMDETAIL$_2 NORMAL NONUNIQUE TablespaceSYSTEM ColumnDETAILOBJ#
Columns
Name Datatype Length Mandatory Comments
SUMOBJ# NUMBER
Yes
DETAILOBJ# NUMBER
Yes
DETAILOBJTYPE NUMBER

DETAILALIAS VARCHAR2 (128)
REFRESHSCN NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (1000)
SPARE4 DATE

INLINE# NUMBER

INSTANCE# NUMBER

DATALESS NUMBER

DETAILEUT NUMBER

QBCID NUMBER
Yes
TABSCNCTR NUMBER

FLAGS NUMBER

Query Text

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


SELECT SUMOBJ#
,      DETAILOBJ#
,      DETAILOBJTYPE
,      DETAILALIAS
,      REFRESHSCN
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      INLINE#
,      INSTANCE#
,      DATALESS
,      DETAILEUT
,      QBCID
,      TABSCNCTR
,      FLAGS
FROM SYS.SUMDETAIL$;

Dependencies

[top of page]

SYS.SUMDETAIL$ does not reference any database object

SYS.SUMDETAIL$ is referenced by following:

SchemaSYS
ViewALL_MVIEW_DETAIL_RELATIONS
ViewALL_MVIEW_KEYS
ViewALL_SUMMARY_DETAIL_TABLES
ViewALL_SUMMARY_KEYS
ViewDBA_MVIEWS
ViewDBA_MVIEW_DETAIL_PARTITION
ViewDBA_MVIEW_DETAIL_RELATIONS
ViewDBA_MVIEW_DETAIL_SUBPARTITION
ViewDBA_MVIEW_KEYS
ViewDBA_SUMMARY_DETAIL_TABLES
ViewDBA_SUMMARY_KEYS
ProcedureDBMS_FEATURE_PARTITION_SYSTEM - show dependent code
ProcedureDBMS_FEATURE_PARTITION_USER - show dependent code
ProcedureDBMS_FEATURE_ZMAP - show dependent code
Package BodyDBMS_SYNC_REFRESH - show dependent code
ViewUSER_MVIEW_DETAIL_RELATIONS
ViewUSER_MVIEW_KEYS
ViewUSER_SUMMARY_DETAIL_TABLES
ViewUSER_SUMMARY_KEYS