Oracle教程 2023-04-03

Oracle 视图 ALL_MVIEW_DETAIL_SUBPARTITION 官方解释，作用，如何使用详细说明

本站中文解释

_VIEW

Oracle视图ALL_MVIEW_DETAIL_SUBPARTITION_VIEW用于显示全部细分，对应到每一个物化视图，它反映细分表上物化视图上每个细分的状态。

这个视图用于显示多个物化视图的每个细分的状态。要使用该视图，显示一个特定物理视图上的每个细分的状态，你可以运行下面的查询：

SELECT *
FROM ALL_MVIEW_DETAIL_SUBPARTITION_VIEW
WHERE Master_View_Name = ‘your_mview_name’;

这将显示给定物理视图上的每个细分的状态。

官方英文解释

ALL_MVIEW_DETAIL_SUBPARTITION displays freshness information, with respect to partition change tracking (PCT) detail subpartitions, for the materialized views accessible to the current user.

Related Views

DBA_MVIEW_DETAIL_SUBPARTITION displays freshness information, with respect to PCT detail subpartitions, for all materialized views in the database.
USER_MVIEW_DETAIL_SUBPARTITION displays freshness information, with respect to PCT detail subpartitions, 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_PARTITION_NAME`	`VARCHAR2(128)`		Name of the detail object partition
`DETAIL_SUBPARTITION_NAME`	`VARCHAR2(128)`		Name of the detail object subpartition
`DETAIL_SUBPARTITION_POSITION`	`NUMBER`		Position of the detail object subpartition
`FRESHNESS`	`CHAR(5)`		Freshness state of the detail object subpartition (`FRESH` or `STALE`)

本站中文解释

官方英文解释

相关推荐