ALL_MVIEW_DETAIL_PARTITION displays the freshness information of the materialized views, with respect to a PCT detail partition, accessible to the current user.
DBA_MVIEW_DETAIL_PARTITION displays freshness information for all materialized views in the database, with respect to a PCT detail partition.
USER_MVIEW_DETAIL_PARTITION displays freshness information for all materialized views, with respect to a PCT detail partition, owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the materialized view |
MVIEW_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the materialized view |
DETAILOBJ_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the detail object |
DETAILOBJ_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the detail object |
DETAIL_PARTITION_NAME |
VARCHAR2(30) |
Name of the detail object partition | |
DETAIL_PARTITION_POSITION |
NUMBER |
Position of the detail object partition | |
FRESHNESS |
CHAR(5) |
Freshness state (FRESH, STALE, UNKNOWN, NA, and so on) |