Timeline for Why in Oracle 11gR2 I can't drop the materialized view with the same user that created it?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 1, 2017 at 6:49 | comment | added | Atilla Ozgur | @awe try to connect your database as / sysdba. Then you can use DROP SUMMARY command. | |
| Apr 17, 2013 at 6:38 | comment | added | awe |
I have this exact problem, and the MV was listed in dba_summaries. The problem is when I try to run DROP SUMMARY MY_OWNER.MY_MATERIALIZED_VIEW;, I get error ORA-00950 ... invalid DROP option.
|
|
| S Aug 3, 2011 at 9:22 | history | suggested | acorello | CC BY-SA 3.0 |
fixed sql code
|
| Aug 3, 2011 at 9:20 | comment | added | acorello | Thanks mate, that was preventing the materialized view to be removed completely... | |
| Aug 3, 2011 at 9:20 | vote | accept | acorello | ||
| Aug 3, 2011 at 9:19 | review | Suggested edits | |||
| S Aug 3, 2011 at 9:22 | |||||
| Aug 2, 2011 at 13:45 | history | answered | Matthew Watson | CC BY-SA 3.0 |