Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Bitmap index creation failed

Re: Bitmap index creation failed

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 21 Oct 2004 13:56:07 +0000 (UTC)
Message-ID: <cl8f5n$e71$1@sparta.btinternet.com>

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
>
>
>
>
>
Received on Thu Oct 21 2004 - 08:56:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US