RE: ORA 28604 - table is too fragmented

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 26 May 2007 11:43:08 +0100
Message-ID: <014401c79f82$a6864250$0200a8c0@Primary>

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_at_discoverfinancial.com
> 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

Received on Sat May 26 2007 - 05:43:08 CDT