Re: Bitmap index creation failed

If you've read the details of the error message, you will have found that Oracle has an indication of the number of rows in the identified block, although it seems a little odd that

1. the max slot count is only 16
2. the max slot found is apparently legal.

If you issue:

    alter table XXX

        minimize records_per_block;

This will scan the table, and re-write the limit that is causing the problem to match the current state of the table; after which you should be able to build the index

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th





"hastenthunder" <hastenthunder_at_hotmail.com> wrote in message 
news:Tezdd.1669$Ny6.2641_at_mencken.net.nih.gov...


> Have anyone encountered the following error when creating bitmap index?

>

>    ORA-28604: table too fragmented to build bitmap index (22495432,16,16)

>

> The SQL command that caused the above error is: create bitmap index xxx on

> record(abc) tablespace idx_tbs;

> I am using Oracle 10.1.0.2.0 on Red Hat Enterprise 3.0

>

> Thanks

>

>

>

>

>