Oracle Error ORA-30355: materialized view container does not exist

Oracle Error Message

ORA-30355: materialized view container does not exist

Reason for the Error

A DROP TABLE command was issued directly against the materialized view container table.

Solution

Use the DROP MATERIALIZED VIEW command to clean up the residual meta data for the materialized view. Then use the CREATE MATERIALIZED VIEW statement to recreate the materialized view. Thereafter, use the DROP MATERIALIZED VIEW command rather than the DROP TABLE command to drop a materialized view.