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