../E40402-16.epub /> ../E40402-16.mobi />

ALL_MVIEW_DETAIL_PARTITION

ALL_MVIEW_DETAIL_PARTITION displays the freshness information of the materialized views, with respect to a PCT detail partition, accessible to the current user.

Related Views

  • 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)