RE: CHAINED ROWS

From: Babich , Sergey <SBabich_at_handexmail.com>
Date: Tue, 08 Jan 2002 08:30:14 -0800
Message-ID: <F001.003E9A8E.20020108074532@fatcity.com>

It
depends on the number. If it's a real high number on the tables that are actively involved in OLTP (or just queried a lot, for that matter), chained (or migrated) rows will definitely slow down the processing. In this case you can either use EXP/IMP on the tables or create a copy of the table (CTAS), truncate the table and INSERT INTO ...(...) SELECT (*)...; <FONT face=Arial color=#0000ff
size=2>Regards,
Sergey
Babich,
Oracle
DBA   <FONT face=Tahoma
  size=2>-----Original Message-----From: Bunyamin K. Karadeniz   [mailto:bunyamink_at_havelsan.com.tr]Sent: Tuesday, January 08, 2002   8:36 AMTo: Multiple recipients of list ORACLE-LSubject:   CHAINED ROWS
  I have seen that There are some number of   chained rows in several tables of a schema in my database .   What is it done in such a situation ?

Thank you
Bunyamin Received on Tue Jan 08 2002 - 10:30:14 CST