Oracle 视图 DBA_MVIEW_DETAIL_RELATIONS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_MVIEW_DETAIL_RELATIONS是Oracle数据库中数据字典视图,用来获取符合主表/细节表之间关系快照清单,增量求精快照所必需映射的列构成。它包含有关当前数据库中增量求精的细节表的元数据的列的信息。我们可以使用该视图来跟踪增量快照执行过程中的各种细节,列出符合主表/细节表之间的快照映射的列的列表,查看与主表或细节表关联的细节表的信息,及查看细节表中各列的值。
官方英文解释
DBA_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
.
See Also:
“ALL_MVIEW_DETAIL_RELATIONS”