Dropping a Materialized View

To drop any materialized view, issue the DROP VIEW statement.

The following statement drops the sample_mv materialized view.

Command> DROP VIEW sample_mv;

See SQL Statements chapter in the Oracle TimesTen In-Memory Database SQL Reference.