DROP MATERIALIZED VIEW LOG

Purpose

Use the DROP MATERIALIZED VIEW LOG statement to remove a materialized view log from the database.

The terms "snapshot" and "materialized view" are synonymous.

See Also: CREATE MATERIALIZED VIEW and ALTER MATERIALIZED VIEW for more information on materialized views CREATE MATERIALIZED VIEW LOG for information on materialized view logs Oracle8i Replication for information on materialized views in a replication environment Oracle8i Data Warehousing Guide for information on materialized views in a data warehousing environment

Prerequisites

A materialized view log consists of a table and a trigger. To drop a materialized view log, you must have the privileges needed to drop a table.

See Also: DROP TABLE

Syntax

Keywords and Parameters

schema

Specify the schema containing the materialized view log and its master table. If you omit schema, Oracle assumes the materialized view log and master table are in your own schema.

table

Specify the name of the detail table associated with the materialized view log to be dropped.

After you drop a materialized view log, some materialized views based on the materialized view log's detail table can no longer be fast refreshed. These materialized views include rowid materialized views, primary key materialized views, and subquery materialized views.

See Also: Oracle8i Data Warehousing Guide for a description of the types of materialized views

Example

DROP MATERIALIZED VIEW LOG Example

The following statement drops the materialized view log on the parts master table:

DROP MATERIALIZED VIEW LOG ON parts;