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]

TABLE: SYSTEM.MVIEW$_ADV_LEVEL

Object Details

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

Level definition

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: MVIEW$_ADV_LEVEL_PK

RUNID#
LEVELID#

Indexes

Index	Type	Uniqueness	Tablespace	Column
MVIEW$_ADV_LEVEL_PK	NORMAL	UNIQUE	SYSTEM	RUNID# LEVELID#

Foreign Keys

Table	Foreign Table	Foreign Key Column
MVIEW$_ADV_LEVEL	MVIEW$_ADV_LOG	MVIEW$_ADV_LEVEL RUNID#
MVIEW$_ADV_ROLLUP	MVIEW$_ADV_LEVEL	MVIEW$_ADV_ROLLUP RUNID# MVIEW$_ADV_ROLLUP PLEVELID#
MVIEW$_ADV_ROLLUP	MVIEW$_ADV_LEVEL	MVIEW$_ADV_ROLLUP RUNID# MVIEW$_ADV_ROLLUP CLEVELID#

Columns

Name	Datatype	Length	Mandatory
RUNID#	NUMBER		Yes
LEVELID#	NUMBER		Yes
DIMOBJ#	NUMBER
FLAGS	NUMBER		Yes
TBLOBJ#	NUMBER		Yes
COLUMNLIST	RAW	(70)	Yes
LEVELNAME	VARCHAR2	(128)

Query Text

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


SELECT RUNID#
,      LEVELID#
,      DIMOBJ#
,      FLAGS
,      TBLOBJ#
,      COLUMNLIST
,      LEVELNAME
FROM SYSTEM.MVIEW$_ADV_LEVEL;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_LEVEL does not reference any database object

SYSTEM.MVIEW$_ADV_LEVEL is referenced by following:

SYS: PRVT_WORKLOAD - show dependent code