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

TABLE: SYSTEM.MVIEW$_ADV_INFO

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

Internal table for passing information from the SQL analyzer

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: MVIEW$_ADV_INFO_PK
  1. ColumnRUNID#
  2. ColumnSEQ#
Indexes
Index Type Uniqueness Tablespace Column
MVIEW$_ADV_INFO_PK NORMAL UNIQUE TablespaceSYSTEM ColumnRUNID#
ColumnSEQ#
Foreign Keys
Table
Foreign Table Foreign Key Column
MVIEW$_ADV_INFO MVIEW$_ADV_INFO_FK TableMVIEW$_ADV_LOG MVIEW$_ADV_INFO RUNID#
Columns
Name Datatype Length Mandatory Comments
RUNID# NUMBER
Yes
SEQ# NUMBER
Yes
TYPE NUMBER
Yes
INFOLEN NUMBER
Yes
INFO LONG RAW (0)
STATUS NUMBER

FLAG NUMBER

Query Text

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


SELECT RUNID#
,      SEQ#
,      TYPE
,      INFOLEN
,      INFO
,      STATUS
,      FLAG
FROM SYSTEM.MVIEW$_ADV_INFO;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_INFO does not reference any database object

SYSTEM.MVIEW$_ADV_INFO is referenced by following:

SchemaSYS
Package BodyPRVT_WORKLOAD - show dependent code