ORA 28604 - table is too fragmented
- From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 18 May 2007 11:03:24 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
