> I received the following error when trying to create a bitmap index:
>
> 28604, 00000, "table too fragmented to build bitmap index (%s,%s,%s)"
> // *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)
> // *Action: Defragment the table or block(s). Use the values in the
> message
> // to determine the FIRST block affected. (There may be others).
>
> How do deleted rows mess up the slot count?
> What sql could I issue to find this out?
> What additional sql would indicate that a table should be reorged?
>
> Thanks,
> Alan Martin
> Oracle DBA - GMAC Insurance
> Winston-Salem, NC
> alan.martin_at_gmacinsurance.com
>
Note: The information contained in this message may be privileged and confidential
and protected from disclosure. If the reader of this message is not the intended recipient,
or an employee or agent responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution or copying of this communication
is strictly prohibited. If you have received this communication in error, please notify us
immediately by replying to the message and deleting it from your computer. Thank you.
Received on Wed Nov 22 2000 - 12:11:35 CST
