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

CHAR(5)

  

Freshness state (FRESH, STALE, UNKNOWN, NA, and so on)

See Also: