Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 10 of 30
To remove an existing materialized view from the database.
The terms "snapshot" and "materialized view" are synonymous.
See Also:
|
The materialized view must be in your own schema or you must have the DROP
ANY
MATERIALIZED
VIEW
(or DROP
ANY
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.
For information on these privileges, see "DROP TABLE", "DROP VIEW", and "DROP INDEX".
The following statement drops the materialized view PARTS
owned by the user HQ
:
DROP SNAPSHOT hq.parts;
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 CREATE MATERIALIZED VIEW
statement with the ON PREBUILT TABLE
clause):
DROP MATERIALIZED VIEW sales_by_month;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|