Oracle Database Discussions

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.