DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_ZONEMAP_MEASURES

Object Details
Object Name: DBA_ZONEMAP_MEASURES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All zonemap measures in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Zonemap owner name
ZONEMAP_NAME VARCHAR2 (128) Yes Zonemap name
MEASURE LONG (0)
Column whose MIN/MAX materialized
POSITION_IN_SELECT NUMBER
Yes Ordinal position of measure aggregate
AGG_FUNCTION VARCHAR2 (13)
Type of aggregate function: MIN/MAX
AGG_COLUMN_NAME VARCHAR2 (128) Yes Aggregate column name in zonemap table
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      ZONEMAP_NAME
,      MEASURE
,      POSITION_IN_SELECT
,      AGG_FUNCTION
,      AGG_COLUMN_NAME
FROM SYS.DBA_ZONEMAP_MEASURES;

Dependencies

[top of page]

SYS.DBA_ZONEMAP_MEASURES references the following:

SchemaSYS
TableCOL$
TableOBJ$
TableSNAP$
TableSUM$
TableSUMAGG$
TableUSER$
SYS.DBA_ZONEMAP_MEASURES is referenced by following:

SchemaPUBLIC
SynonymDBA_ZONEMAP_MEASURES
SchemaSYS
ViewALL_ZONEMAP_MEASURES
ViewUSER_ZONEMAP_MEASURES