Oracle教程 2023-02-23

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

本站中文解释

Oracle视图all_registered_mviews提供了有关被注册的复合物理视图（即物化视图）的元数据信息，可用于查询和更新复合视图的详细内容、定义、内部表结构等内容。该视图可为复合视图的创建者提供查询和管理的能力。

使用方法：

1、找出特定的复合视图：下面的SQL查询可以查询特定的复合视图：

SELECT * FROM all_registered_mviews WHERE mview_name = ‘MY_MVIEW’;

2、查找所有复合视图：下面的SQL查询可以查询数据库中所有复合视图：

SELECT * FROM all_registered_mviews;

官方英文解释

ALL_REGISTERED_MVIEWS describes all registered materialized views (registered at a master site or a master materialized view site) accessible to the current user.

A materialized view created with the BUILD DEFERRED option of the CREATE MATERIALIZED VIEW statement is only registered with ALL_REGISTERED_MVIEWS if that materialized view has been completely refreshed at least once.

Related Views

DBA_REGISTERED_MVIEWS describes all registered materialized views in the database.
USER_REGISTERED_MVIEWS describes all registered materialized views owned by the current user.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the materialized view
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the materialized view
`MVIEW_SITE`	`VARCHAR2(128)`	`NOT NULL`	Global name of the materialized view site
`CAN_USE_LOG`	`VARCHAR2(3)`		Indicates whether the materialized view can use a materialized view log (`YES`) or the materialized view is too complex to use a log (`NO`)
`UPDATABLE`	`VARCHAR2(3)`		Indicates whether the materialized view is updatable (`YES`) or not and the materialized view is read only (`NO`)
`REFRESH_METHOD`	`VARCHAR2(11)`		Indicates whether the materialized view uses primary key (`PRIMARY KEY`), rowids (`ROWID`), or object identifiers (`OBJECT ID`) for fast refresh
`MVIEW_ID`	`NUMBER(38)`		Identifier for the materialized view used by the masters for fast refresh
`VERSION`	`VARCHAR2(26)`		Oracle version of the materialized view Note: Oracle Database materialized views show `ORACLE 8 MATERIALIZED VIEW`.
`QUERY_TXT`	`LONG`		Query that defines the materialized view

本站中文解释

官方英文解释

相关推荐