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_KEYSdescribes such columns and expressions for all materialized views in the database. -
USER_MVIEW_KEYSdescribes 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 |
VARCHAR2(128) |
NOT NULL |
Owner of the materialized view |
MVIEW_NAME |
VARCHAR2(128) |
NOT NULL |
Materialized view name |
POSITION_IN_SELECT |
NUMBER |
NOT NULL |
Ordinal position of this key within the SELECT list |
CONTAINER_COLUMN |
VARCHAR2(128) |
NOT NULL |
Name of the column in the container table |
DETAILOBJ_OWNER |
VARCHAR2(128) |
NOT NULL |
Detail object owner |
DETAILOBJ_NAME |
VARCHAR2(128) |
NOT NULL |
Detail object name (for example, the name of a table or view) |
DETAILOBJ_ALIAS |
VARCHAR2(128) |
Implicit or explicit alias for detail relation | |
DETAILOBJ_TYPE |
VARCHAR2(5) |
Detail object type:
|
|
DETAILOBJ_COLUMN |
VARCHAR2(128) |
NOT NULL |
Name of the detail relation column |
See Also: