DROP MATERIALIZED ZONEMAP

Note:

The DROP MATERIALIZED ZONEMAP statement is available starting with Oracle Database 12c Release 1 (12.1.0.2).

Purpose

Use the DROP MATERIALIZED ZONEMAP statement to remove an existing zone map from the database.

Prerequisites

The zone map must be in your own schema or you must have the DROP ANY MATERIALIZED VIEW system privilege. You must also have the privileges to drop the internal table and indexes that the database uses to maintain the zone map data.

See Also:

DROP TABLE and DROP INDEX for information on privileges required to drop objects that the database uses to maintain the zone map

Syntax

drop_materialized_zonemap::=

Description of drop_materialized_zonemap.gif follows
Description of the illustration drop_materialized_zonemap.gif

Semantics

schema

Specify the schema containing the zone map. If you omit schema, then Oracle Database assumes the zone map is in your own schema.

zonemap_name

Specify the name of the existing zone map to be dropped.

Example

Dropping a Zone Map: Examples The following statement drops the zone map sales_zmap:

DROP MATERIALIZED ZONEMAP sales_zmap;