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

本站中文解释

Oracle视图ALL_MVIEW_COMMENTS是用于获取物化视图注释信息的内置视图。通过 ALL_MVIEW_COMMENTS 视图，您可以查询有关所有物化视图的说明信息。

使用方法：

1、查询物化视图的注释信息：

SELECT * FROM ALL_MVIEW_COMMENTS WHERE MVIEW_NAME = ‘view_name’;

2、查询表空间中包含的所有物化视图的注释信息：

SELECT * FROM ALL_MVIEW_COMMENTS WHERE TABLESPACE_NAME = ‘tablespace_name’;

官方英文解释

ALL_MVIEW_COMMENTS displays comments on the materialized views accessible to the current user.

Related Views

• DBA_MVIEW_COMMENTS displays comments on the materialized views in the database.

• USER_MVIEW_COMMENTS displays comments on the materialized views owned by the current user. This view does not display the OWNER column.

See Also:

• “DBA_MVIEW_COMMENTS”

• “USER_MVIEW_COMMENTS”