Re: Chained_Rows
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 21 Jan 2001 00:37:29 -0800
Message-ID: <3A6A9FC9.A4D30D49_at_exesolutions.com>
Date: Sun, 21 Jan 2001 00:37:29 -0800
Message-ID: <3A6A9FC9.A4D30D49_at_exesolutions.com>
> What is the quickest way to get rid of chained rows wuthout losing data and
> without stopping the database ? It's an oracle 7.3.4 database.
Rename the table to something like mytable_bak
Create a new table with the proper storage clause. Insert the data into the new table. Drop the old table. Recompile any code that may have become invalid when the table was renamed.
And if you ever build a table without specifying a storage clause. You will repeat this and other bad experiences on a regular basis.
Daniel A. Morgan Received on Sun Jan 21 2001 - 09:37:29 CET