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

本站中文解释

User_Mview_Detail_Relations视图是Oracle数据库中用来提供详细分析复杂视图关系和物化视图主表及索引定义的SQL视图。

用途：
1.查看当前用户下的所有物化视图的主表及索引定义；
2.查看各个物化视图的具体表与表之间的联系；
3.查看物化视图与分区表的关系；

使用方法：
1.查看所有物化视图的定义：
SELECT *
FROM User_Mview_Detail_Relations
WHERE Type = ‘MVIEW’;

2.查看特定物化视图的定义：
SELECT *
FROM User_Mview_Detail_Relations
WHERE Type = ‘MVIEW’
AND View_Name = ”;

3.查看特定物化视图的主表及分区或索引：
SELECT *
FROM User_Mview_Detail_Relations
WHERE Type IN (‘TABLE’, ‘INDEX’, ‘PARTITION’)
AND View_Name = ”;

官方英文解释

USER_MVIEW_DETAIL_RELATIONS represents the named detail relations that are either in the FROM list of a materialized view, or that are indirectly referenced through views in the FROM list. Its columns are the same as those in ALL_MVIEW_DETAIL_RELATIONS.