|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 19 of 26
LOG statement to remove a materialized view log from the database.
To drop a materialized view log, you must have the privileges needed to drop a table.
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.
Specify the name of the master 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 master table can no longer be fast refreshed. These materialized views include rowid materialized views, primary key materialized views, and subquery materialized views.
Oracle9i Data Warehousing Guide for a description of these types of materialized views
The following statement drops the materialized view log on the
oe.customers master table: