RE: ORA 28604 - table is too fragmented

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 26 May 2007 11:43:08 +0100


I know I'm coming into this one rather late, but do you have table compression enabled
for the table suffering the problem ?


Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


Subject: RE: ORA 28604 - table is too fragmented
From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
Date: Tue, 22 May 2007 11:16:16 -0500

Jacques,

This seems to work. Thank you very much ! I have been able to build all
indices without problems and run exchange
with a partitioned table with no issues (so far) after increasing the
pctfree parameter

thank you

Gene Gurevich

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


Other related posts: