Oracle 视图 ALL_MVIEW_DETAIL_RELATIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_MVIEW_DETAIL_RELATIONS存储了物化视图中涉及到的详细表之间的关系信息。
它包含物化视图与详细表之间的表名、列名和级联关系。
用途：
ALL_MVIEW_DETAIL_RELATIONS视图可以用来跟踪物化视图及其详细表之间的关系、理解物化视图的组成，以及针对物化视图的其他操作，如备份、还原或故障排除。
使用方法：
要使用ALL_MVIEW_DETAIL_RELATIONS视图，首先要连接到数据库，然后可以执行SELECT语句，检索相关视图范围内涉及到的详细表和物化视图，然后就可以查询物化视图与详细表之间的关系了。
官方英文解释
ALL_MVIEW_DETAIL_RELATIONS describes the named detail relations that are either specified in the FROM list of the subquery that defines a materialized view accessible to the current user, or that are indirectly referenced through views in that FROM list. Inline views in the materialized view definition are not represented in this view or the related views.
Related Views
-
DBA_MVIEW_DETAIL_RELATIONSdescribes all such detail relations defined for all materialized views in the database. -
USER_MVIEW_DETAIL_RELATIONSdescribes such detail relations defined 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 of the materialized view |
|
|
|
|
Name of the materialized view |
|
|
|
|
Detail object owner |
|
|
|
|
Detail object name (that is, the name of a table or view) |
|
|
|
Detail object type:
|
|
|
|
|
Implicit or explicit alias for detail relation |
|
|
|
|
Indicates whether the detail object PCT is supported ( |
|
|
|
|
Number of fresh PCT partitions |
|
|
|
|
Number of stale PCT partitions |
See Also:
-
“DBA_MVIEW_DETAIL_RELATIONS”
-
“USER_MVIEW_DETAIL_RELATIONS”
