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)