ORA 28604 - table is too fragmented

Hi all:

I am running oracle 9.2.0.4 and am getting the following error when
building bitmap indices:
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
 ORA-28604: TABLE TOO FRAGMENTED TO BUILD BITMAP INDEX (25206487,40,40)     
                                                                            
                                                                            


I have found the note 119674 and applied the first solution that was
recommended - rebuild the table through
export/import - I have copied the data from the table into another table,
dropped and recreate my table
and inserted the data back. After that I tried to rebuild the indices and
received the same error. I looked
at the second solution and it looks like a reduced version of the first
one.

I have temporarily rebuilt all bitmap indices as non-bitmap to allow the
user testing to go on, but
I would still like to have the bitmap indices instead. Does anyone have a
better solution for this?

thank you

Gene Gurevich


--
http://www.freelists.org/webpage/oracle-l

Other related posts: