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

VIEW: SYS.ALL_ZONEMAPS

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

Zonemaps accessible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Zonemap owner name
ZONEMAP_NAME VARCHAR2 (128)
Zonemap name
FACT_OWNER VARCHAR2 (128)
Fact table owner name
FACT_TABLE VARCHAR2 (128)
Fact table name
SCALE NUMBER

Zonemap scale factor
HIERARCHICAL VARCHAR2 (12)
Zonemap is hierarchical or not
WITH_CLUSTERING VARCHAR2 (15)
Is zonemap created with clustering clause
QUERY LONG (0)
Zonemap defining query
QUERY_LEN NUMBER

Zonemap defining query length
PRUNING VARCHAR2 (8)
Zonemap enabled for pruning or not
REFRESH_MODE VARCHAR2 (17)
Refresh on: commit/demand/load/datamovement
REFRESH_METHOD VARCHAR2 (14)
Refresh method: force/complete/fast
LAST_REFRESH_METHOD VARCHAR2 (19)
Refresh method used last time
LAST_REFRESH_TIME TIMESTAMP(9) (20)
Time last refresh occurred
INVALID VARCHAR2 (7)
Zonemap invalid (due to some DDL) or not
STALE VARCHAR2 (7)
Zonemap fully stale or not
UNUSABLE VARCHAR2 (8)
Zonemap marked unusable (by user) or not
COMPILE_STATE VARCHAR2 (19)
Zonemap compile state
Query Text

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


SELECT OWNER
,      ZONEMAP_NAME
,      FACT_OWNER
,      FACT_TABLE
,      SCALE
,      HIERARCHICAL
,      WITH_CLUSTERING
,      QUERY
,      QUERY_LEN
,      PRUNING
,      REFRESH_MODE
,      REFRESH_METHOD
,      LAST_REFRESH_METHOD
,      LAST_REFRESH_TIME
,      INVALID
,      STALE
,      UNUSABLE
,      COMPILE_STATE
FROM SYS.ALL_ZONEMAPS;

Dependencies

[top of page]

SYS.ALL_ZONEMAPS references the following:

SchemaSYS
ViewDBA_ZONEMAPS
TableOBJ$
TableOBJAUTH$
TableUSER$
SYS.ALL_ZONEMAPS is referenced by following:

SchemaPUBLIC
SynonymALL_ZONEMAPS