Oracle Error ORA-28670: mapping table cannot be dropped due to an existing bitmap index

Oracle Error Message

ORA-28670: mapping table cannot be dropped due to an existing bitmap index

Reason for the Error

User attempted to drop the mapping table with NOMAPPING option when the IOT has one or more bitmap indexed.

Solution

Drop the bitmap index(es) before dropping the mapping table.