ALL_MVIEW_DETAIL_LOGICAL_PARTITION
ALL_MVIEW_DETAIL_LOGICAL_PARTITION displays freshness information, with respect to logical partition change tracking (LPCT) detail partitions, for the materialized views accessible to the current user.
Related Views
-
DBA_MVIEW_DETAIL_LOGICAL_PARTITIONdisplays freshness information, with respect to LPCT detail partitions, for all materialized views in the database. -
USER_MVIEW_DETAIL_LOGICAL_PARTITIONdisplays freshness information, with respect to LPCT 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_LOGICAL_PARTITION_NAME |
VARCHAR2(128) |
Name of the detail object logical partition | |
DETAIL_LOGICAL_PARTITION_NUMBER |
NUMBER |
NOT NULL |
Unique identifier of the detail object logical partition |
FRESHNESS |
VARCHAR2(7) |
<p>Freshness state of the detail object logical partition. Possible values: <ul 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 | |
DETAIL_LOGICAL_PARTITION_HIBOUND |
LONG |
High bound value for the detail object logical partition | |
DETAIL_INTERVALFoot 1 |
VARCHAR2(1000) |
String of the detail object logical partition interval value | |
DETAIL_LOGICAL_PARTITION_KEYFoot 1 |
VARCHAR2(128) |
Name of the detail object logical partition key column |
Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.3.
Note: This view is available starting with Oracle AI Database 26ai.