3.301 ALL_MVIEW_DETAIL_LOGICAL_PARTITION

ALL_MVIEW_DETAIL_LOGICAL_PARTITION displays freshness information, with respect to logical partition change tracking (LPCT) detail partitions, for the materialized views accessible to the current user.

Related Views

• DBA_MVIEW_DETAIL_LOGICAL_PARTITION displays freshness information, with respect to LPCT detail partitions, for all materialized views in the database.

• USER_MVIEW_DETAIL_LOGICAL_PARTITION displays freshness information, with respect to LPCT detail partitions, for the materialized views 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_LOGICAL_PARTITION_NAME	VARCHAR2(128)		Name of the detail object logical partition
DETAIL_LOGICAL_PARTITION_NUMBER	NUMBER	NOT NULL	Unique identifier of the detail object logical partition
FRESHNESS	VARCHAR2(7)		Freshness state of the detail object logical partition. Possible values: FRESH STALE UNKNOWN
LAST_REFRESH_TIME	DATE		Date and time at which the materialized view was last refreshed
DETAIL_LOGICAL_PARTITION_HIBOUND	LONG		High bound value for the detail object logical partition

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_MVIEW_DETAIL_LOGICAL_PARTITION"

• "USER_MVIEW_DETAIL_LOGICAL_PARTITION"