RE: ** chained rows fixing

Hi

>I need to get rid of chained rows for some tables.

As David told you, you have to find out if they are chained, migrated or both.

If they are chained only a larger block size can solve the problem without reviewing your database design. If you cannot solve the problem you may reduce its impact by placing infrequently accessed large columns "at the end" of the table, in fact only the needed row pieces are read.

HTH
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Zürich (11-Oct), Hamburg (13-Oct), München (20-Oct), Basel (25-Oct),

         Frankfurt (27-Oct), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart (13-Dec)

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