[Home] [Help] [Dependency Information]
Object Name: | MVIEW$_ADV_FILTERINSTANCE |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Table for workload filter instance definition
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Table | |
Foreign Table | Foreign Key Column | MVIEW$_ADV_FILTERINSTANCE | MVIEW$_ADV_LOG | MVIEW$_ADV_FILTERINSTANCE RUNID# |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RUNID# | NUMBER | Yes | ||
FILTERID# | NUMBER | |||
SUBFILTERNUM# | NUMBER | |||
SUBFILTERTYPE | NUMBER | |||
STR_VALUE | VARCHAR2 | (1028) | ||
NUM_VALUE1 | NUMBER | |||
NUM_VALUE2 | NUMBER | |||
DATE_VALUE1 | DATE | |||
DATE_VALUE2 | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT RUNID#
, FILTERID#
, SUBFILTERNUM#
, SUBFILTERTYPE
, STR_VALUE
, NUM_VALUE1
, NUM_VALUE2
, DATE_VALUE1
, DATE_VALUE2
FROM SYSTEM.MVIEW$_ADV_FILTERINSTANCE;
SYSTEM.MVIEW$_ADV_FILTERINSTANCE does not reference any database object
SYSTEM.MVIEW$_ADV_FILTERINSTANCE is referenced by following:
|
|
|