Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

RMAN-06723: file "string" (string bytes) updated in catalog

1 Answers  


ORA-29367: object string does not exist

1 Answers  


ORA-19579: archivelog record for string not found

1 Answers  


ORA-36694: (XSRELTBL01) The value cannot be added to dimension workspace object.

1 Answers  


ORA-32145: Environment not specified

1 Answers  






ORA-29312: changes by release string cannot be used by release string, type: string

1 Answers  


ORA-02345: cannot create a view with column based on CURSOR operator

1 Answers  


ORA-15037: disk 'string' is smaller than mimimum of string MBs

1 Answers  


ORA-15093: buffer only contains string bytes, I/O requested is string bytes

1 Answers  


ORA-29868: cannot issue DDL on a domain index marked as LOADING

1 Answers  


LSX-00110: facet "~S" should have single value attribute

1 Answers  


ORA-02750: osnfsmmap: cannot open shared memory file ?/dbs/ftt_<pid>.dbf

1 Answers  






Categories