3.327 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

DETAIL_INTERVALFoot 1

VARCHAR2(1000)

  

String of the detail object logical partition interval value

DETAIL_LOGICAL_PARTITION_KEYFoot 1

VARCHAR2(128)

  

Name of the detail object logical partition key column

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.3.

Note:

This view is available starting with Oracle AI Database 26ai.

See Also: