DROP MATERIALIZED VIEW LOG / SNAPSHOT LOG

Syntax

Purpose

To remove a materialized view log from the database.

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

See Also: "CREATE MATERIALIZED VIEW / SNAPSHOT" and "ALTER MATERIALIZED VIEW / SNAPSHOT" for more information on materialized views, including a description of the various types of materialized views and refreshing materialized views. "CREATE MATERIALIZED VIEW LOG / SNAPSHOT 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 listed for "DROP TABLE".

Keywords and Parameters

schema	is 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	is 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. For a description of the types of materialized views, see Oracle8i Data Warehousing Guide.

Example

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

DROP MATERIALIZED VIEW LOG ON parts;