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]

VIEW: SYS.ALL_MVIEWS

Object Details

Object Name:	ALL_MVIEWS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All materialized views in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the materialized view
MVIEW_NAME	VARCHAR2	(128)	Yes	Name of the materialized view
CONTAINER_NAME	VARCHAR2	(128)	Yes	Name of the materialized view container table
QUERY	LONG	(0)		The defining query that the materialized view instantiates
QUERY_LEN	NUMBER			The number of bytes in the defining query (based on the server character set
UPDATABLE	VARCHAR2	(1)		Indicates whether the materialized view can be updated
UPDATE_LOG	VARCHAR2	(128)		Name of the table that logs changes to an updatable materialized view
MASTER_ROLLBACK_SEG	VARCHAR2	(128)		Name of the rollback segment to use at the master site
MASTER_LINK	VARCHAR2	(128)		Name of the database link to the master site
REWRITE_ENABLED	VARCHAR2	(1)		Indicates whether rewrite is enabled for the materialized view
REWRITE_CAPABILITY	VARCHAR2	(9)		Indicates the kind of rewrite that is enabled
REFRESH_MODE	VARCHAR2	(6)		Indicates how and when the materialized view will be refreshed
REFRESH_METHOD	VARCHAR2	(8)		The default refresh method for the materialized view (complete, fast, ...)
BUILD_MODE	VARCHAR2	(9)		How and when to initially build (load) the materialized view container
FAST_REFRESHABLE	VARCHAR2	(18)		Indicates the kinds of operations that can be fast refreshed for the MV
LAST_REFRESH_TYPE	VARCHAR2	(8)		Indicates the kind of refresh that was last performed on the MV
LAST_REFRESH_DATE	DATE			The date that the materialized view was last refreshed
LAST_REFRESH_END_TIME	DATE			The time that the last materialized view refresh ended
STALENESS	VARCHAR2	(19)		Indicates the staleness state of the materialized view (fresh, stale, ...)
AFTER_FAST_REFRESH	VARCHAR2	(19)		Indicates the staleness state the MV will have after a fast refresh is done
UNKNOWN_PREBUILT	VARCHAR2	(1)		Indicates if the materialized view is prebuilt
UNKNOWN_PLSQL_FUNC	VARCHAR2	(1)		Indicates if the materialized view contains PL/SQL function
UNKNOWN_EXTERNAL_TABLE	VARCHAR2	(1)		Indicates if the materialized view contains external tables
UNKNOWN_CONSIDER_FRESH	VARCHAR2	(1)		Indicates if the materialized view is considered fresh
UNKNOWN_IMPORT	VARCHAR2	(1)		Indicates if the materialized view is imported
UNKNOWN_TRUSTED_FD	VARCHAR2	(1)		Indicates if the materialized view used trusted constraints for refresh
COMPILE_STATE	VARCHAR2	(19)		Indicates the validity of the MV meta-data
USE_NO_INDEX	VARCHAR2	(1)		Indicates whether the MV uses no index
STALE_SINCE	DATE			Time from when the materialized view became stale
NUM_PCT_TABLES	NUMBER			Number of PCT detail tables
NUM_FRESH_PCT_REGIONS	NUMBER			Number of fresh PCT partition regions
NUM_STALE_PCT_REGIONS	NUMBER			Number of stale PCT partition regions
SEGMENT_CREATED	VARCHAR2	(3)		Whether the materialized view segment is created or not
EVALUATION_EDITION	VARCHAR2	(128)		Name of the evaluation edition assigned to the materialized view subquery
UNUSABLE_BEFORE	VARCHAR2	(128)		Name of the oldest edition eligible for query rewrite
UNUSABLE_BEGINNING	VARCHAR2	(128)		Name of the oldest edition in which query rewrite becomes perpetually disabled

Query Text

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


SELECT OWNER
,      MVIEW_NAME
,      CONTAINER_NAME
,      QUERY
,      QUERY_LEN
,      UPDATABLE
,      UPDATE_LOG
,      MASTER_ROLLBACK_SEG
,      MASTER_LINK
,      REWRITE_ENABLED
,      REWRITE_CAPABILITY
,      REFRESH_MODE
,      REFRESH_METHOD
,      BUILD_MODE
,      FAST_REFRESHABLE
,      LAST_REFRESH_TYPE
,      LAST_REFRESH_DATE
,      LAST_REFRESH_END_TIME
,      STALENESS
,      AFTER_FAST_REFRESH
,      UNKNOWN_PREBUILT
,      UNKNOWN_PLSQL_FUNC
,      UNKNOWN_EXTERNAL_TABLE
,      UNKNOWN_CONSIDER_FRESH
,      UNKNOWN_IMPORT
,      UNKNOWN_TRUSTED_FD
,      COMPILE_STATE
,      USE_NO_INDEX
,      STALE_SINCE
,      NUM_PCT_TABLES
,      NUM_FRESH_PCT_REGIONS
,      NUM_STALE_PCT_REGIONS
,      SEGMENT_CREATED
,      EVALUATION_EDITION
,      UNUSABLE_BEFORE
,      UNUSABLE_BEGINNING
FROM SYS.ALL_MVIEWS;

Dependencies

[top of page]

SYS.ALL_MVIEWS references the following:

SYS: DBA_MVIEWS; OBJ$; OBJAUTH$; USER$

SYS.ALL_MVIEWS is referenced by following:

PUBLIC: ALL_MVIEWS
SYS: ALL_MVIEW_REFRESH_TIMES; XS_DATA_SECURITY_UTIL - show dependent code