Oracle Error ORA-37409: cannot delete or truncate AW used by CUBE ORGANIZED table

Oracle Error Message

ORA-37409: cannot delete or truncate AW used by CUBE ORGANIZED table

Reason for the Error

User attempted to delete or truncate an AW which currently has a CUBE ORGANIZED table or MV defined over it

Solution

Drop the corresponding table or MV before deleting the AW