Oracle教程 2023-03-24

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

本站中文解释

说明

ALL_MVIEW_JOINS表是Oracle的一个系统数据字典视图，用于展示物化视图(Materialized Views)中所涉及到的连接关系，具体包括视图名称、列信息、表名及其列等。

通常由DBA负责操作该视图，目的是分析视图是否满足特定需求，以及按需调整物化视图的表连接信息。使用的SQL语句如下：

SELECT * FROM ALL_MVIEW_JOINS;

官方英文解释

ALL_MVIEW_JOINS describes joins between two columns in the WHERE clause of the subquery that defines a materialized view accessible to the current user.

Related Views

DBA_MVIEW_JOINS describes all such joins for all materialized views in the database.
USER_MVIEW_JOINS describes such joins for all materialized views owned by the current user.

Note:

All three views exclude materialized views that reference remote tables or that includes references to a nonstatic value such as SYSDATE or USER. These views also exclude materialized views that were created as “snapshots” before Oracle8i and that were never altered to enable query rewrite.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the materialized view
`MVIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Materialized view name
`DETAILOBJ1_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the first object in the join^Foot 1
`DETAILOBJ1_RELATION`	`VARCHAR2(128)`	`NOT NULL`	Name of the first object in the join^Foot 1
`DETAILOBJ1_COLUMN`	`VARCHAR2(128)`	`NOT NULL`	Join column of the first object in the join^Foot 1
`OPERATOR`	`CHAR(1)`		Join operator^Foot 1
`OPERATOR_TYPE`	`VARCHAR2(1)`		Indicates whether the join is an inner join (`I`) or the `DETAILOBJ1` table is the left side of an outer join (`L`)^Foot 1
`DETAILOBJ2_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the second object in the join^Foot 1
`DETAILOBJ2_RELATION`	`VARCHAR2(128)`	`NOT NULL`	Name of the second object in the join^Foot 1
`DETAILOBJ2_COLUMN`	`VARCHAR2(128)`	`NOT NULL`	Join column of the second object in the join^Foot 1

^Footnote 1

These rows relate only to materialized join views and materialized aggregate views. They describe the two detail objects of a materialized view join.

本站中文解释

官方英文解释

相关推荐