2.225 ALL_MVIEW_DETAIL_RELATIONS
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_RELATIONS
describes all such detail relations defined for all materialized views in the database. -
USER_MVIEW_DETAIL_RELATIONS
describes 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: