Oracle Error ORA-37410: cannot delete or modify AW object referenced by CUBE ORGANIZED table

Oracle Error Message

ORA-37410: cannot delete or modify AW object referenced by CUBE ORGANIZED table

Reason for the Error

User attempted to delete, chgdfn, or otherwise modify an object referenced by a CUBE ORGANIZED table or MV

Solution

Drop the corresponding table or MV before manipulating the object