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

TABLE: SYSTEM.MVIEW$_ADV_ROLLUP

Object Details
Object Name: MVIEW$_ADV_ROLLUP
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Each row repesents either a functional dependency or join-key relationship

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: MVIEW$_ADV_ROLLUP_PK
  1. ColumnRUNID#
  2. ColumnCLEVELID#
  3. ColumnPLEVELID#
Indexes
Index Type Uniqueness Tablespace Column
MVIEW$_ADV_ROLLUP_PK NORMAL UNIQUE TablespaceSYSTEM ColumnRUNID#
ColumnCLEVELID#
ColumnPLEVELID#
Foreign Keys
Table
Foreign Table Foreign Key Column
MVIEW$_ADV_ROLLUP MVIEW$_ADV_ROLLUP_CFK TableMVIEW$_ADV_LEVEL MVIEW$_ADV_ROLLUP RUNID#
MVIEW$_ADV_ROLLUP CLEVELID#
MVIEW$_ADV_ROLLUP MVIEW$_ADV_ROLLUP_PFK TableMVIEW$_ADV_LEVEL MVIEW$_ADV_ROLLUP RUNID#
MVIEW$_ADV_ROLLUP PLEVELID#
MVIEW$_ADV_ROLLUP MVIEW$_ADV_ROLLUP_FK TableMVIEW$_ADV_LOG MVIEW$_ADV_ROLLUP RUNID#
Columns
Name Datatype Length Mandatory Comments
RUNID# NUMBER
Yes
CLEVELID# NUMBER
Yes
PLEVELID# NUMBER
Yes
FLAGS NUMBER
Yes
Query Text

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


SELECT RUNID#
,      CLEVELID#
,      PLEVELID#
,      FLAGS
FROM SYSTEM.MVIEW$_ADV_ROLLUP;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_ROLLUP does not reference any database object

SYSTEM.MVIEW$_ADV_ROLLUP is referenced by following:

SchemaSYS
Package BodyPRVT_WORKLOAD - show dependent code