2.223 ALL_MVIEW_DETAIL_SUBPARTITION
ALL_MVIEW_DETAIL_SUBPARTITION displays the freshness information of the materialized views, with respect to a PCT detail subpartition, accessible to the current user.
Related Views
-
DBA_MVIEW_DETAIL_SUBPARTITIONdisplays freshness information for all materialized views in the database, with respect to a PCT detail subpartition. -
USER_MVIEW_DETAIL_SUBPARTITIONdisplays freshness information for all materialized views, with respect to a PCT detail subpartition, owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the materialized view |
|
|
|
|
Name of the materialized view |
|
|
|
|
Owner of the detail object |
|
|
|
|
Name of the detail object |
|
|
|
|
Name of the detail object partition |
|
|
|
|
Name of the detail object subpartition |
|
|
|
|
Position of the detail object subpartition |
|
|
|
|
Freshness state (FRESH, STALE, UNKNOWN, NA, and so on) |
See Also: