Skip to content

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

VIEW: SYS.CDB_ZONEMAPS

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

All zonemaps in the database in all containers

[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_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
CON_ID NUMBER

container id
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_LEN
,      PRUNING
,      REFRESH_MODE
,      REFRESH_METHOD
,      LAST_REFRESH_METHOD
,      LAST_REFRESH_TIME
,      INVALID
,      STALE
,      UNUSABLE
,      COMPILE_STATE
,      CON_ID
FROM SYS.CDB_ZONEMAPS;

Dependencies

[top of page]

SYS.CDB_ZONEMAPS does not reference any database object

SYS.CDB_ZONEMAPS is referenced by following:

SchemaPUBLIC
SynonymCDB_ZONEMAPS