|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
CREATE SYNONYM to DROP ROLLBACK SEGMENT, 23 of 31
VIEW statement to remove an existing materialized view from the database.
The terms "snapshot" and "materialized view" are synonymous.
The materialized view must be in your own schema or you must have the
SNAPSHOT) system privilege. You must also have the privileges to drop the internal table, views, and index that Oracle uses to maintain the materialized view's data.
Specify the schema containing the materialized view. If you omit
schema, Oracle assumes the materialized view is in your own schema.
Specify the name of the existing materialized view to be dropped.
The following statement drops the materialized view
parts owned by the user
The following statement drops the
sales_by_month materialized view and the underlying table of the materialized view (unless the underlying table was registered in the
VIEW statement with the