Dropping a materialized view
You must understand when to drop a materialized view to successfully drop related tables.
Drop a materialized view before performing a DROP TABLE operation on a related table. You cannot drop a table that has a relationship with a materialized view.
In this task, you drop a materialized view named mv1 from the database named default.
Drop a materialized view in my_database named mv1 .
DROP MATERIALIZED VIEW default.mv;