Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
CREATE TYPE to
DROP ROLLBACK SEGMENT, 19 of 26
Use the DROP
MATERIALIZED
VIEW
LOG
statement to remove a materialized view log from the database.
See Also:
|
To drop a materialized view log, you must have the privileges needed to drop a table.
drop_materialized_view_log::=
drop_materialized_view_log
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.
DROP
MATERIALIZED
VIEW
LOG
Example
The following statement drops the materialized view log on the customers
master table:
DROP MATERIALIZED VIEW LOG ON customers;
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|