2.218 ALL_MVIEW_AGGREGATES

ALL_MVIEW_AGGREGATES describes the grouping functions (aggregate operations) that appear in the SELECT list of materialized aggregate views accessible to the current user.

Related Views

  • DBA_MVIEW_AGGREGATES describes all such grouping functions defined for all materialized views in the database.

  • USER_MVIEW_AGGREGATES describes all such grouping functions defined for all materialized views owned by the current user.

Note:

All three views exclude materialized views that reference remote tables or that include 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

Name of the materialized view

POSITION_IN_SELECT

NUMBER

NOT NULL

Ordinal position of this aggregation within the SELECT list. For the position of nonaggregate elements of the select list, see "ALL_MVIEW_KEYS".

CONTAINER_COLUMN

VARCHAR2(128)

NOT NULL

Name of this column in the container table

AGG_FUNCTION

VARCHAR2(8)

Aggregation function

DISTINCTFLAG

VARCHAR2(1)

Indicates whether this aggregation is distinct (Y) or not (N)

MEASURE

LONG

SQL text of the measure, excluding the aggregation function. Equal to * for COUNT(*).