Oracle 视图 DBA_REGISTERED_MVIEWS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle 视图 DBA_REGISTERED_MVIEWS 可用来查询特定的物化视图的注释、快照、最后更新时间及其它相关信息。
用法:
SELECT * FROM DBA_REGISTERED_MVIEWS;
这将会列出所有已经注册了物化视图的ID、名称、注释等信息。
另外,可以执行以下语句以检查特定的物化视图:
SELECT * FROM DBA_REGISTERED_MVIEWS WHERE MV_NAME = ”;
官方英文解释
DBA_REGISTERED_MVIEWS
describes all registered materialized views (registered at a master site or a master materialized view site) in the database. Its columns are the same as those in ALL_REGISTERED_MVIEWS
.
See Also:
“ALL_REGISTERED_MVIEWS”