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

PCC-01202: Identifier "string" truncated to 31 characters

1 Answers  


ORA-24183: invalid transformation

1 Answers  


ORA-08197: Flashback Table operation is not supported on clustered tables

1 Answers  


ORA-13213: failed to generate spatial index for window object

1 Answers  


ORA-26090: row is in partial state

1 Answers  






ORA-27411: An empty string is not a valid repeat interval.

1 Answers  


CLSR-00504: Error number encountered when posting an EVM event

1 Answers  


ORA-00352: all logs for thread string need to be archived - cannot enable

1 Answers  


ORA-00348: single-process redo failure. Must abort instance

1 Answers  


ORA-01228: SET DATABASE option required to install seed database

1 Answers  


ORA-25409: failover happened during the network operation,cannot continue

1 Answers  


ORA-02334: cannot infer type for column

1 Answers  


Categories