Table: ALL_REGISTERED_MVIEWS
Remote materialized views of local tables that the user can see
| Column Name | Description |
|---|---|
| CAN_USE_LOG | If NO, this materialized view is complex and cannot fast refresh |
| MVIEW_ID | Identifier for the materialized view used by the master for fast refresh |
| MVIEW_SITE | Global name of the materialized view site |
| NAME | The name of the materialized view |
| OWNER | Owner of the materialized view |
| QUERY_TXT | Query defining the materialized view |
| REFRESH_METHOD | Whether the materialized view uses rowid or primary key or object id for fast refresh |
| UPDATABLE | If NO, the materialized view is read only |
| VERSION | Version of materialized view |