Friday, August 12, 2022

ORA-28604 table too fragmented to build

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



    Oracle Database Error Code Messages ORA-28604 About Help Description;

Table too fragmented to build bitmap index (string,string,string).

    

    Error Cause;

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).

How to Solve and Fix;ORA-28604 table too fragmented to build bitmap index (string,string,string).

    Action for Solve Fix;

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

0 comments:

Post a Comment

Featured Post

Ora-00921 Unexpected end of SQL Command

 ORA-00921 unexpected end of SQL command     Oracle Database Error Code Messages ORA-00921 About Help Description; Unexpected end of SQL com...

Search This Blog