ALL_ZONEMAP_MEASURES

Previous Next JavaScript must be enabled to correctly display this content

3.168 ALL_ZONEMAP_MEASURES

ALL_ZONEMAP_MEASURES describes the measures for all zone maps accessible to the user.

Related Views

DBA_ZONEMAP_MEASURES describes the measures for all the zone maps in the database.
USER_ZONEMAP_MEASURES describes the measures for all the zone maps owned by the user.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the zone map
`ZONEMAP_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the zone map
`MEASURE`	`LONG`		Column whose `MIN/MAX` value is computed
`POSITION_IN_SELECT`	`NUMBER`	`NOT NULL`	Original position of the mesaure aggregate on the `SELECT` list of zone map defining query
`AGG_FUNCTION`	`VARCHAR2(13)`		Name of aggregate in zone map table
`AGG_COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the column whose `MIN/MAX` per zone maintained

Note:

This view is intended for use with Oracle Exadata release 12.1.2.1.1 or later.

See Also:

"DBA_ZONEMAP_MEASURES"
"USER_ZONEMAP_MEASURES"
Oracle Database Data Warehousing Guide for more information about zone maps