Oracle教程 2023-02-25

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

本站中文解释

ALL_ZONEMAPS视图显示用户拥有权限跨数据库链接后所定义的所有复杂网络区域地图，这些地图用于将连接从一个数据库到另一个数据库的物理位置映射到网络地址，以及将网络地址映射回物理位置。

使用方法：通过对ALL_ZONEMAPS视图的查询，可以获得网络段和逻辑位置映射的相关信息。例如，下面的查询列出了最新的三个版本的网络地图：

SELECT version, zone_name, map_type
FROM all_zonemaps
ORDER BY version DESC
LIMIT 3;

官方英文解释

ALL_ZONEMAPS describes all the zone maps accessible to the user.

Related Views

DBA_ZONEMAPS describes all the zone maps in the database.
USER_ZONEMAPS describes all the zone maps owned by the user.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Owner of the zone map
`ZONEMAP_NAME`	`VARCHAR2(128)`	Name of the zone map
`FACT_OWNER`	`VARCHAR2(128)`	Owner of the fact table of the zone map
`FACT_TABLE`	`VARCHAR2(128)`	Name of the fact table on which the zone map is defined
`SCALE`	`NUMBER`	Scale factor of the zone map
`HIERARCHICAL`	`VARCHAR2(12)`	Indicates whether the zone map is hierarchical (`YES`) or not (`NO`)
`WITH_CLUSTERING`	`VARCHAR2(15)`	Indicates whether the zone map is created with the `CLUSTERING` clause (`YES`) or not (`NO`)
`AUTOMATIC`^Foot 1	`VARCHAR2(9)`	Indicates whether the zone map is automatic (`YES`) or not (`NO`)
`QUERY`	`LONG`	Zone map defining query
`QUERY_LEN`	`NUMBER(38)`	Length of defining query in bytes
`PRUNING`	`VARCHAR2(8)`	Indicates whether the zone map is enabled for pruning (`ENABLED`) or not (`DISABLED`)
`REFRESH_MODE`	`VARCHAR2(17)`	Refresh mode for the zone map: `COMMIT` `DEMAND` `DATAMOVEMENT` `LOAD` `LOAD` `DATAMOVEMENT`
`REFRESH_METHOD`	`VARCHAR2(14)`	Refresh method for the zone map `COMPLETE` `FORCE` `FAST`
`LAST_REFRESH_METHOD`	`VARCHAR2(19)`	The last refresh method used for the zone map: `NA` `COMPLETE` `FAST` `ERROR-UNKNOWN`
`LAST_REFRESH_TIME`	`TIMESTAMP(9)`	Time of the last refresh
`INVALID`	`VARCHAR2(7)`	Indicates whether the zone map is invalid due to some DDL (`YES`) or not (`NO`)
`STALE`	`VARCHAR2(7)`	Indicates whether the zone map is stale because of DML operations and cannot be used for pruning (`YES`) or not (`NO`), or whether this cannot be determined (`UNKNOWN`)
`PARTLY_STALE`^Foot 1	`VARCHAR2(12)`	Indicates whether the zone map is partly stale (`YES`) or not (`NO`), or whether this cannot be determined (`UNKNOWN`). A partly stale zone map contains both fresh and stale zones.
`INCOMPLETE`^Foot 1	`VARCHAR2(12)`	Indicates whether the zone map has missing zones (`YES`) or not (`NO`), or whether this cannot be determined (`UNKNOWN`). Missing zones result when data is added to the base table and a subsequent refresh of the zone map is not performed.
`UNUSABLE`	`VARCHAR2(8)`	Indicates whether the zone map has been marked unusable by the owner (`YES`) or not (`NO`)
`COMPILE_STATE`	`VARCHAR2(19)`	Current compile state of the zone map: `VALID` `AUTHORIZATION_ERROR` `COMPILATION_ERROR` `NEEDS_COMPILE` `ERROR_UNKNOWN` Similar to `ALL_MVIEWS`.`COMPILE_STATE`.

^Footnote 1This column is available starting with Oracle Database 21c.

Note:

This view is intended for use with Oracle Exadata release 12.1.2.1.1 or later.

本站中文解释

官方英文解释

相关推荐