Oracle Error ORA-28604: table too fragmented to build bitmap index (string,string,string)

Oracle Error Message

ORA-28604: table too fragmented to build bitmap index (string,string,string)

Reason for the Error

The table has one or more blocks that exceed the maximum number of rows expected when creating a bitmap index. This is probably due to deleted rows. The values in the message are: (data block address, slot number found, maximum slot allowed)

Solution

Defragment the table or block(s). Use the values in the message to determine the FIRST block affected. (There may be others).