home - keyword index

Table: USER_MVIEWS

All materialized views in the database

Column Name Description
AFTER_FAST_REFRESH Indicates the staleness state the MV will have after a fast refresh is done
BUILD_MODE How and when to initially build (load) the materialized view container
COMPILE_STATE Indicates the validity of the MV meta-data
CONTAINER_NAME Name of the materialized view container table
FAST_REFRESHABLE Indicates the kinds of operations that can be fast refreshed for the MV
LAST_REFRESH_DATE The date that the materialized view was last refreshed
LAST_REFRESH_TYPE Indicates the kind of refresh that was last performed on the MV
MASTER_LINK Name of the database link to the master site
MASTER_ROLLBACK_SEG Name of the rollback segment to use at the master site
MVIEW_NAME Name of the materialized view
OWNER Owner of the materialized view
QUERY The defining query that the materialized view instantiates
QUERY_LEN The number of bytes in the defining query (based on the server character set
REFRESH_METHOD The default refresh method for the materialized view (complete, fast, ...)
REFRESH_MODE Indicates how and when the materialized view will be refreshed
REWRITE_CAPABILITY Indicates the kind of rewrite that is enabled
REWRITE_ENABLED Indicates whether rewrite is enabled for the materialized view
STALENESS Indicates the staleness state of the materialized view (fresh, stale, ...)
UNKNOWN_CONSIDER_FRESH Indicates if the materialized view is considered fresh
UNKNOWN_EXTERNAL_TABLE Indicates if the materialized view contains external tables
UNKNOWN_IMPORT Indicates if the materialized view is imported
UNKNOWN_PLSQL_FUNC Indicates if the materialized view contains PL/SQL function
UNKNOWN_PREBUILT Indicates if the materialized view is prebuilt
UPDATABLE Indicates whether the materialized view can be updated
UPDATE_LOG Name of the table that logs changes to an updatable materialized view
USE_NO_INDEX Indicates whether the MV uses no index

home - keyword index

Comment on this page: