DBA_MVIEW_DETAIL_PARTITION

DBA_MVIEW_DETAIL_PARTITION displays freshness information for all materialized views in the database, with respect to a PCT detail partition. Its columns are the same as those in "ALL_MVIEW_DETAIL_PARTITION".

Related Views

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

· 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	Name of the owner of the materialized view
MVIEW_NAME	VARCHAR2(30)	NOT NULL	Name of the materialzed view
DETAILOBJ_OWNER	VARCHAR2(30)	NOT NULL	Name of the 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)

Oracle data dictionary views

Oracle dynamic performance views