Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

RE: ORA 28604 - table is too fragmented

Jonathan Lewis

2007-05-26



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@(protected)
> 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
>
--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.