ALL_MVIEW_DETAIL_PARTITION
ALL_MVIEW_DETAIL_PARTITION displays freshness information, with respect to partition change tracking (PCT) detail partitions, for the materialized views accessible to the current user.
Related Views
-
DBA_MVIEW_DETAIL_PARTITIONdisplays freshness information, with respect to PCT detail partitions, for all materialized views in the database. -
USER_MVIEW_DETAIL_PARTITIONdisplays freshness information, with respect to PCT detail partitions, for the materialized views owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the materialized view |
MVIEW_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the materialized view |
DETAILOBJ_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the detail object |
DETAILOBJ_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the detail object |
DETAIL_PARTITION_NAME |
VARCHAR2(128) |
Name of the detail object partition | |
DETAIL_PARTITION_POSITION |
NUMBER |
Position of the detail object partition | |
FRESHNESS |
VARCHAR2(7) |
<p>Freshness state of the detail object logical partition. Possible values: <ul id="GUID-9418D5CD-D137-44CE-8581-AFE561AF3230__UL_FV3_4LS_5SB" style="list-style-type: disc;"> <li>FRESH</li> <li>STALE</li> <li>UNKNOWN</li> </ul> </p> |
|
LAST_REFRESH_TIME |
DATE |
Date and time at which the materialized view was last refreshed |
See Also: