ORA-30355: materialized view container does not exist



ORA-30355: materialized view container does not exist..

Answer / guest

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

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00639: Cannot specify destination offset in a LOB WRITE APPEND

1 Answers  


ORA-24501: invalid UTF16 string passed in

1 Answers  


ORA-31030: Unable to retrieve XML document

1 Answers  


PCC-02426: Incompatible LOB types

1 Answers  


ORA-14191: ALLOCATE STORAGE may not be specified for Composite Range partitioned object

1 Answers  


PLS-00584: size of an opaque type must be between 1 and 4000 bytes

1 Answers  


RMAN-06446: changed proxy copy unavailable

1 Answers  


ORA-38956: Target platform string not cross platform compliant

1 Answers  


NNL-00414: Maximum response time: string

1 Answers  


ORA-09874: TASDEF_READ: read error, unable to read tasdef@.dbf file.

1 Answers  


ORA-01188: Block size string in header does not match physical block size string

1 Answers  


ORA-27025: skgfqsbi: invalid media manager context area size

1 Answers  


Categories