| Column Name
| Description
|
| AFTER_FAST_REFRESH (ALL_MVIEWS)
| Indicates the staleness state the MV will have after a fast refresh is done
|
| AFTER_FAST_REFRESH (USER_MVIEWS)
| Indicates the staleness state the MV will have after a fast refresh is done
|
| AFTER_FAST_REFRESH (DBA_MVIEWS)
| Indicates the staleness state the MV will have after a fast refresh is done
|
| CACHE_REFRESHES (V$SESSION_OBJECT_CACHE)
|
|
| CACHE_REFRESHES (GV$SESSION_OBJECT_CACHE)
|
|
| FAST_REFRESHABLE (DBA_MVIEWS)
| Indicates the kinds of operations that can be fast refreshed for the MV
|
| FAST_REFRESHABLE (ALL_MVIEWS)
| Indicates the kinds of operations that can be fast refreshed for the MV
|
| FAST_REFRESHABLE (USER_MVIEWS)
| Indicates the kinds of operations that can be fast refreshed for the MV
|
| INC_REFRESHABLE (DBA_SUMMARIES)
| This summary is not restricted from being incrementally refreshed
|
| INC_REFRESHABLE (ALL_SUMMARIES)
| This summary is not restricted from being incrementally refreshed
|
| INC_REFRESHABLE (DBA_MVIEW_ANALYSIS)
| This materialized view is not restricted from being incrementally refreshed
|
| INC_REFRESHABLE (ALL_MVIEW_ANALYSIS)
| This materialized view is not restricted from being incrementally refreshed
|
| INC_REFRESHABLE (USER_MVIEW_ANALYSIS)
| This materialized view is not restricted from being incrementally refreshed
|
| INC_REFRESHABLE (USER_SUMMARIES)
| This summary is not restricted from being incrementally refreshed
|
| LAST_REFRESH (USER_SNAPSHOTS)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH (ALL_SNAPSHOTS)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH (USER_SNAPSHOT_REFRESH_TIMES)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH (ALL_MVIEW_REFRESH_TIMES)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH (ALL_SNAPSHOT_REFRESH_TIMES)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH (DBA_MVIEW_REFRESH_TIMES)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH (DBA_SNAPSHOT_REFRESH_TIMES)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH (USER_MVIEW_REFRESH_TIMES)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH (DBA_SNAPSHOTS)
| SYSDATE from the master site at the time of the last refresh
|
| LAST_REFRESH_DATE (USER_MVIEWS)
| The date that the materialized view was last refreshed
|
| LAST_REFRESH_DATE (DBA_MVIEWS)
| The date that the materialized view was last refreshed
|
| LAST_REFRESH_DATE (DBA_SUMMARIES)
| The date of the last refresh of the summary
|
| LAST_REFRESH_DATE (ALL_MVIEWS)
| The date that the materialized view was last refreshed
|
| LAST_REFRESH_DATE (USER_MVIEW_ANALYSIS)
| The date of the last refresh of the materialized view
|
| LAST_REFRESH_DATE (DBA_MVIEW_ANALYSIS)
| The date of the last refresh of the materialized view
|
| LAST_REFRESH_DATE (USER_SUMMARIES)
| The date of the last refresh of the summary
|
| LAST_REFRESH_DATE (ALL_MVIEW_ANALYSIS)
| The date of the last refresh of the materialized view
|
| LAST_REFRESH_DATE (ALL_SUMMARIES)
| The date of the last refresh of the summary
|
| LAST_REFRESH_SCN (ALL_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
| LAST_REFRESH_SCN (ALL_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
| LAST_REFRESH_SCN (DBA_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
| LAST_REFRESH_SCN (USER_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
| LAST_REFRESH_SCN (DBA_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
| LAST_REFRESH_SCN (USER_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
| LAST_REFRESH_TYPE (ALL_MVIEWS)
| Indicates the kind of refresh that was last performed on the MV
|
| LAST_REFRESH_TYPE (USER_MVIEWS)
| Indicates the kind of refresh that was last performed on the MV
|
| LAST_REFRESH_TYPE (DBA_MVIEWS)
| Indicates the kind of refresh that was last performed on the MV
|
| 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 (DBA_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
|
| OBJECT_REFRESHES (GV$SESSION_OBJECT_CACHE)
|
|
| OBJECT_REFRESHES (V$SESSION_OBJECT_CACHE)
|
|
| OLDEST_REFRESH_DATE (ALL_REFRESH_DEPENDENCIES)
| The oldest date scn of a dependent materialized view
|
| OLDEST_REFRESH_SCN (ALL_REFRESH_DEPENDENCIES)
| The oldest scn of a dependent materialized view
|
| REFRESH_AFTER_ERRORS (DBA_REFRESH)
| If Y, proceed with refresh despite error when pushing deferred RPCs
|
| REFRESH_AFTER_ERRORS (USER_REFRESH_CHILDREN)
| If Y, proceed with refresh despite error when pushing deferred RPCs
|
| REFRESH_AFTER_ERRORS (ALL_REFRESH)
| If Y, proceed with refresh despite error when pushing deferred RPCs
|
| REFRESH_AFTER_ERRORS (DBA_RGROUP)
| If Y, proceed with refresh despite error when pushing deferred RPCs
|
| REFRESH_AFTER_ERRORS (ALL_REFRESH_CHILDREN)
| If Y, proceed with refresh despite error when pushing deferred RPCs
|
| REFRESH_AFTER_ERRORS (DBA_REFRESH_CHILDREN)
| If Y, proceed with refresh despite error when pushing deferred RPCs
|
| REFRESH_AFTER_ERRORS (USER_REFRESH)
| If Y, proceed with refresh despite error when pushing deferred RPCs
|
| REFRESH_GROUP (ALL_SNAPSHOTS)
| All snapshots in a given refresh group get refreshed in the same transaction
|
| REFRESH_GROUP (DBA_SNAPSHOTS)
| All snapshots in a given refresh group get refreshed in the same transaction
|
| REFRESH_GROUP (USER_SNAPSHOTS)
| All snapshots in a given refresh group get refreshed in the same transaction
|
| REFRESH_GROUP_ID (DBA_TEMPLATE_REFGROUPS)
| Internal primary key of the refresh groups table.
|
| REFRESH_GROUP_NAME (USER_REPCAT_USER_PARM_VALUES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (ALL_REPCAT_TEMPLATE_PARMS)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (ALL_REPCAT_REFRESH_TEMPLATES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (USER_REPCAT_REFRESH_TEMPLATES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (DBA_IAS_TEMPLATES)
|
|
| REFRESH_GROUP_NAME (ALL_REPCAT_USER_AUTHORIZATIONS)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (ALL_REPCAT_TEMPLATE_SITES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (USER_REPCAT_TEMPLATE_SITES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (DBA_REPCAT_REFRESH_TEMPLATES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (DBA_REPCAT_TEMPLATE_PARMS)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (DBA_REPCAT_USER_AUTHORIZATIONS)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (USER_REPCAT_TEMPLATE_PARMS)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (DBA_TEMPLATE_REFGROUPS)
| Name of the refresh group
|
| REFRESH_GROUP_NAME (ALL_REPCAT_USER_PARM_VALUES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (DBA_REPCAT_TEMPLATE_SITES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (USER_REPCAT_USER_AUTHORIZATION)
| Name of the refresh group to create during instantiation.
|
| REFRESH_GROUP_NAME (DBA_REPCAT_USER_PARM_VALUES)
| Name of the refresh group to create during instantiation.
|
| REFRESH_METHOD (USER_SUMMARIES)
| User declared method of refresh for the summary
|
| REFRESH_METHOD (DBA_SUMMARIES)
| User declared method of refresh for the summary
|
| REFRESH_METHOD (ALL_REGISTERED_SNAPSHOTS)
| Whether the snapshot uses rowid or primary key or object id for fast refresh
|
| REFRESH_METHOD (DBA_SNAPSHOTS)
| The values used to drive a fast refresh of the snapshot
|
| REFRESH_METHOD (USER_MVIEWS)
| The default refresh method for the materialized view (complete, fast, ...)
|
| REFRESH_METHOD (USER_REGISTERED_SNAPSHOTS)
| Whether the snapshot uses rowid or primary key or object id for fast refresh
|
| REFRESH_METHOD (USER_REGISTERED_MVIEWS)
| Whether the materialized view uses rowid or primary key or object id for fast refresh
|
| REFRESH_METHOD (DBA_REGISTERED_SNAPSHOTS)
| Whether the snapshot uses rowid, primary key or object id for fast refresh
|
| REFRESH_METHOD (ALL_SUMMARIES)
| User declared method of refresh for the summary
|
| REFRESH_METHOD (ALL_SNAPSHOTS)
| The values used to drive a fast refresh of the snapshot
|
| REFRESH_METHOD (USER_SNAPSHOTS)
| The values used to drive a fast refresh of the snapshot
|
| REFRESH_METHOD (DBA_MVIEW_ANALYSIS)
| User declared method of refresh for the materialized view
|
| REFRESH_METHOD (DBA_MVIEWS)
| The default refresh method for the materialized view (complete, fast, ...)
|
| REFRESH_METHOD (ALL_MVIEW_ANALYSIS)
| User declared method of refresh for the materialized view
|
| REFRESH_METHOD (USER_MVIEW_ANALYSIS)
| User declared method of refresh for the materialized view
|
| REFRESH_METHOD (DBA_REGISTERED_MVIEWS)
| Whether the materialized view uses rowid, primary key or object id for fast refresh
|
| REFRESH_METHOD (ALL_MVIEWS)
| The default refresh method for the materialized view (complete, fast, ...)
|
| REFRESH_METHOD (ALL_REGISTERED_MVIEWS)
| Whether the materialized view uses rowid or primary key or object id for fast refresh
|
| REFRESH_MODE (USER_SNAPSHOTS)
| This indicates how and when the snapshot will be refreshed
|
| REFRESH_MODE (ALL_MVIEWS)
| Indicates how and when the materialized view will be refreshed
|
| REFRESH_MODE (DBA_MVIEWS)
| Indicates how and when the materialized view will be refreshed
|
| REFRESH_MODE (ALL_SNAPSHOTS)
| This indicates how and when the snapshot will be refreshed
|
| REFRESH_MODE (DBA_SNAPSHOTS)
| This indicates how and when the snapshot will be refreshed
|
| REFRESH_MODE (USER_MVIEWS)
| Indicates how and when the materialized view will be refreshed
|
| REFRESH_TEMPLATE_ID (DBA_TEMPLATE_REFGROUPS)
| Primary key of the template containing the refresh group.
|
| REFRESH_TEMPLATE_NAME (USER_REPCAT_TEMPLATE_PARMS)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (DBA_REPCAT_TEMPLATE_SITES)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (ALL_REPCAT_REFRESH_TEMPLATES)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (ALL_REPCAT_USER_PARM_VALUES)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (USER_REPCAT_TEMPLATE_SITES)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (ALL_REPCAT_TEMPLATE_OBJECTS)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (USER_REPCAT_TEMPLATE_OBJECTS)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (DBA_REPCAT_TEMPLATE_OBJECTS)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (ALL_REPCAT_TEMPLATE_PARMS)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (DBA_REPCAT_USER_PARM_VALUES)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (USER_REPCAT_REFRESH_TEMPLATES)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (DBA_REPCAT_USER_AUTHORIZATIONS)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (ALL_REPCAT_USER_AUTHORIZATIONS)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (DBA_TEMPLATE_REFGROUPS)
| Name of the deployment template containing the refresh group.
|
| REFRESH_TEMPLATE_NAME (USER_REPCAT_USER_PARM_VALUES)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (DBA_REPCAT_REFRESH_TEMPLATES)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (DBA_REPCAT_TEMPLATE_PARMS)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (USER_REPCAT_USER_AUTHORIZATION)
| Name of the refresh group template.
|
| REFRESH_TEMPLATE_NAME (ALL_REPCAT_TEMPLATE_SITES)
| Name of the refresh group template.
|