3.318 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: