In a test environment I dropped a Cube MV with preserve table:
drop materialized view CB$MY_MV_CB preserve table;
It successfully dropped the MV but left the table. Now when I attempt to drop the table, I get:
drop table CB$MY_MV_CB;
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-37406: invalid option for a CUBE ORGANIZED table
How do I get around this?
Of course the "table" is really just an interface to the OLAP cube and using "preserve table" does nothing for me. Even still, I would like to drop the table. Dropping the MV without using "preserve table" successfully drops both the MV and the table. But once they are no longer associated with each other after using preserve table, I'm stuck.
Ideas?