2.225 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

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:

  • TABLE

  • VIEW

DETAILOBJ_COLUMN

VARCHAR2(128)

NOT NULL

Name of the detail relation column