Re: Bitmap index creation failed

Thanks Jonathan,

I seems to be working alright now.
This error is very odd, can anyone offer some insight as why would it happen? I am using locally managed tablespace with automatic extent management on.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:cl8f5n$e71$1_at_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
> a) the max slot count is only 16
> b) 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 Fri Oct 22 2004 - 08:42:35 CDT