RE: ** chained rows fixing
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 5 Oct 2005 10:42:28 -0700 (PDT)
Hi,
I assume 'ALTER TABLE move ...' will fix it and will not affect ORacle
Advanced replication or MV/MV logs etc. I read on asktom that all I need to do
after 'ALTER TABLE.. ' is rebuild indexes. Thanks again for help.
A Joshi <ajoshi977@xxxxxxxxx> wrote:
Thanks to Christian Antognini, Paul Drake, Mladen Gogala, Mark Fanham, Ric Van
Dyke, Allen Brandon, David Sharples and everybody for your help.
I assume a 'ALTER TABLE move should fix the current chained (migrated rows).
For future prevention I have set the PCT_FREE higher. Thanks
Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:
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)
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
Other related posts:
