DROP MATERIALIZED VIEW

Drop an existing mview.

Syntax:

   DROP MATERIALIZED VIEW [schema.] materialized_view

Snapshot is synonymous with Materialized View.

Related Commands:

GRANT ALTER ANY MATERIALIZED VIEW
MVIEW - CREATE MATERIALIZED VIEW
MVIEW - ALTER MATERIALIZED VIEW

Related Views:

 DBA_MVIEWS                 ALL_MVIEWS           USER_MVIEWS
 DBA_MVIEW_AGGREGATES       ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES
 DBA_MVIEW_ANALYSIS         ALL_MVIEW_ANALYSIS   USER_MVIEW_ANALYSIS
 DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS
 DBA_MVIEW_JOINS            ALL_MVIEW_JOINS      USER_MVIEW_JOINS
 DBA_MVIEW_KEYS             ALL_MVIEW_KEYS       USER_MVIEW_KEYS
 DBA_MVIEW_LOGS             ALL_MVIEW_LOGS       USER_MVIEW_LOGS
 DBA_MVIEW_LOG_FILTER_COLS
 DBA_MVIEW_REFRESH_TIMES    ALL_MVIEW_REFRESH_TIMES USER_MVIEW_REFRESH_TIMES