2.228 ALL_MVIEW_KEYS
ALL_MVIEW_KEYS
describes the columns or expressions in the SELECT
list upon which materialized views accessible to the current user are based.
Related Views
-
DBA_MVIEW_KEYS
describes such columns and expressions for all materialized views in the database. -
USER_MVIEW_KEYS
describes such columns and expressions 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 |
|
|
|
Materialized view name |
|
|
|
Ordinal position of this key within the |
|
|
|
Name of the column in the container table |
|
|
|
Detail object owner |
|
|
|
Detail object name (for example, the name of a table or view) |
|
|
|
Implicit or explicit alias for detail relation |
|
|
|
Detail object type:
|
|
|
|
Name of the detail relation column |
See Also: