I have problems with one table that have long I/O waits for delete one
row (20s). I re-create the table with "create table MyTest as select *
from bigtable" and the new table didnt have the I/O problem.

So my thought is I need to rebuild the orginal table to have it the
preformance up to date! I have added some columns to the table and that
was when it started to act badly. A friend of mine said that the data
for the table must be "fragmented" on disc so Oracle need to read/write
form several places to delete my row.

He also said that Move the table to a other tablespace would put all
things in order?

My question what should I use to solve this?

- "alter table bigtable move tablespace x"
- "alter table bigtable move online"
- RDMB_REDEFINITION package? (and does foreign keys to the table
bigtable work?)

My customer is using an Oracle 9 so the Rebuilding Objects in the
Enterprise Manager is not a vlaid option.


Oracle LazyDBA home page