|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
SNAPSHOTis supported in place of
VIEWfor backward compatibility.
CREATE MATERIALIZED VIEW LOG for information on materialized view logs
Oracle Database Advanced Replication for information on materialized views in a replication environment
Oracle Database Data Warehousing Guide for information on materialized views in a data warehousing environment
To drop a materialized view log, you must have the privileges needed to drop a table.
See Also:DROP TABLE
Specify the schema containing the materialized view log and its master table. If you omit
schema, then Oracle Database 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 master table can no longer be fast refreshed. These materialized views include rowid materialized views, primary key materialized views, and subquery materialized views.
See Also:Oracle Database Data Warehousing Guide for a description of these types of materialized views
Dropping a Materialized View Log: Example The following statement drops the materialized view log on the
oe.customers master table:
DROP MATERIALIZED VIEW LOG ON customers;