ALL_MVIEW_DETAIL

2.224 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(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_PARTITION_NAME`	`VARCHAR2(128)`		Name of the detail object partition
`DETAIL_PARTITION_POSITION`	`NUMBER`		Position of the detail object partition
`FRESHNESS`	`VARCHAR2(7)`		Freshness state (`FRESH`, `STALE`, `UNKNOWN`, `NA`, and so on)
`LAST_REFRESH_TIME`^Foot 1	`DATE`		Date when the materialized view was last refreshed

^Footnote 1This column is available starting with Oracle Database release 19c, version 19.1.