ALL_REGISTERED_MVIEWS
describes all registered materialized views (registered at a master site or a master materialized view site) accessible to the current user.
A materialized view created with the BUILD DEFERRED
option of the CREATE MATERIALIZED VIEW
statement is only registered with ALL_REGISTERED_MVIEWS
if that materialized view has been completely refreshed at least once.
Related Views
DBA_REGISTERED_MVIEWS
describes all registered materialized views in the database.
USER_REGISTERED_MVIEWS
describes all registered materialized views owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the materialized view |
|
|
|
Name of the materialized view |
|
|
|
Global name of the materialized view site |
|
|
Indicates whether the materialized view can use a materialized view log ( |
|
|
|
Indicates whether the materialized view is updatable ( |
|
|
|
Indicates whether the materialized view uses primary key ( |
|
|
|
Identifier for the materialized view used by the masters for fast refresh |
|
|
|
Oracle version of the materialized view Note: Oracle Database materialized views show |
|
|
|
Query that defines the materialized view |
See Also: