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 |