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 |