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

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

The following is the cause of this 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)

Action you can take to resolve this issue: Defragment the table or block(s). Use the values in the message to determine the FIRST block affected (there may be others).


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution