Oracle Solution for Error ora-30355

ORA-30355: materialized view container does not exist

What triggered the Error:

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

What should we do to fix it:

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.