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