Keyword: MVIEW
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_BASE_TABLE_MVIEWS | All materialized views with log(s) in the database that the user can see |
| ALL_MVIEWS | All materialized views in the database |
| ALL_MVIEW_AGGREGATES | Description of the materialized view aggregates accessible to the user |
| ALL_MVIEW_ANALYSIS | Description of the materialized views accessible to the user |
| ALL_MVIEW_DETAIL_RELATIONS | Description of the materialized view detail tables accessible to the user |
| ALL_MVIEW_JOINS | Description of a join between two columns in the WHERE clause of a materialized view accessible to the user |
| ALL_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user |
| ALL_MVIEW_LOGS | All materialized view logs in the database that the user can see |
| ALL_MVIEW_REFRESH_TIMES | Materialized views and their last refresh times for each master table that the user can look at |
| ALL_REGISTERED_MVIEWS | Remote materialized views of local tables that the user can see |
| DBA_BASE_TABLE_MVIEWS | All materialized views with log(s) in the database |
| DBA_MVIEWS | All materialized views in the database |
| DBA_MVIEW_AGGREGATES | Description of the materialized view aggregates accessible to dba |
| DBA_MVIEW_ANALYSIS | Description of the materialized views accessible to dba |
| DBA_MVIEW_DETAIL_RELATIONS | Description of the materialized view detail tables accessible to dba |
| DBA_MVIEW_JOINS | Description of a join between two columns in the WHERE clause of a materialized view accessible to dba |
| DBA_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view accessible to dba |
| DBA_MVIEW_LOGS | All materialized view logs in the database |
| DBA_MVIEW_LOG_FILTER_COLS | All filter columns (excluding PK cols) being logged in the materialized view logs |
| DBA_MVIEW_REFRESH_TIMES | All fast refreshable materialized views and their last refresh times for each master table |
| DBA_REGISTERED_MVIEWS | Remote materialized views of local tables |
| DBA_REGISTERED_MVIEW_GROUPS | Materialized view repgroup registration information |
| USER_BASE_TABLE_MVIEWS | All materialized views with log(s) owned by the user in the database |
| USER_MVIEWS | All materialized views in the database |
| USER_MVIEW_AGGREGATES | Description of the materialized view aggregates created by the user |
| USER_MVIEW_ANALYSIS | Description of the materialized views created by the user |
| USER_MVIEW_DETAIL_RELATIONS | Description of the materialized view detail tables of the materialized views created by the user |
| USER_MVIEW_JOINS | Description of a join between two columns in the WHERE clause of a materialized view created by the user |
| USER_MVIEW_KEYS | Description of the columns that appear in the GROUP BY list of a materialized view created by the user |
| USER_MVIEW_LOGS | All materialized view logs owned by the user |
| USER_MVIEW_REFRESH_TIMES | Materialized views and their last refresh times for each master table that the user can look at |
| USER_REGISTERED_MVIEWS | Remote materialized views of local tables currently using logs owned by the user |
Columns
| Column Name | Description |
|---|---|
| MVIEW_ID (USER_BASE_TABLE_MVIEWS) | Unique identifier of the materialized view |
| MVIEW_ID (ALL_BASE_TABLE_MVIEWS) | Unique identifier of the materialized view |
| MVIEW_ID (USER_REGISTERED_MVIEWS) | Identifier for the materialized view used by the master for fast refresh |
| MVIEW_ID (DBA_BASE_TABLE_MVIEWS) | Unique identifier of the materialized view |
| MVIEW_ID (DBA_REGISTERED_MVIEWS) | Identifier for the materialized view used by the master for fast refresh |
| MVIEW_ID (ALL_REGISTERED_MVIEWS) | Identifier for the materialized view used by the master for fast refresh |
| MVIEW_LAST_REFRESH_TIME (DBA_BASE_TABLE_MVIEWS) | One date per materialized view -- the date the materialized view was last refreshed |
| MVIEW_LAST_REFRESH_TIME (USER_BASE_TABLE_MVIEWS) | One date per materialized view -- the date the materialized view was last refreshed |
| MVIEW_LAST_REFRESH_TIME (ALL_BASE_TABLE_MVIEWS) | One date per materialized view -- the date the materialized view was last refreshed |
| MVIEW_NAME (DBA_MVIEW_JOINS) | Name of the materialized view |
| MVIEW_NAME (ALL_MVIEW_AGGREGATES) | Name of the materialized view |
| MVIEW_NAME (USER_MVIEW_DETAIL_RELATIONS) | Name of the materialized view |
| MVIEW_NAME (DBA_MVIEWS) | Name of the materialized view |
| MVIEW_NAME (DBA_MVIEW_KEYS) | Name of the materialized view |
| MVIEW_NAME (USER_MVIEW_AGGREGATES) | Name of the materialized view |
| MVIEW_NAME (ALL_MVIEW_JOINS) | Name of the materialized view |
| MVIEW_NAME (DBA_MVIEW_ANALYSIS) | Name of the materialized view |
| MVIEW_NAME (DBA_MVIEW_AGGREGATES) | Name of the materialized view |
| MVIEW_NAME (DBA_MVIEW_DETAIL_RELATIONS) | Name of the materialized view |
| MVIEW_NAME (ALL_MVIEW_KEYS) | Name of the materialized view |
| MVIEW_NAME (USER_MVIEW_ANALYSIS) | Name of the materialized view |
| MVIEW_NAME (USER_MVIEW_JOINS) | Name of the materialized view |
| MVIEW_NAME (ALL_MVIEWS) | Name of the materialized view |
| MVIEW_NAME (USER_MVIEWS) | Name of the materialized view |
| MVIEW_NAME (USER_MVIEW_KEYS) | Name of the materialized view |
| MVIEW_NAME (ALL_MVIEW_ANALYSIS) | Name of the materialized view |
| MVIEW_NAME (ALL_MVIEW_DETAIL_RELATIONS) | Name of the materialized view |
| MVIEW_SITE (USER_REGISTERED_MVIEWS) | Global name of the materialized view site |
| MVIEW_SITE (DBA_REGISTERED_MVIEW_GROUPS) | Database site of the materialized view repgroup |
| MVIEW_SITE (ALL_REGISTERED_MVIEWS) | Global name of the materialized view site |
| MVIEW_SITE (DBA_REGISTERED_MVIEWS) | Global name of the materialized view site |
| MVIEW_TABLE_OWNER (ALL_MVIEW_ANALYSIS) | Owner of the container table |
| MVIEW_TABLE_OWNER (DBA_MVIEW_ANALYSIS) | Owner of the container table |
| MVIEW_TABLE_OWNER (USER_MVIEW_ANALYSIS) | Owner of the container table |