Hi Friends..

I have used OEM Tablespace Map and noticed that one of my segments has excessive chasining/migration. This can be resolved through OEM by using the re-organisation wizard.

I am wondering if there is an equivalent way of eliminating this through sqlplus instead of using OEM. I have always thought that the way to do this through sqlplus would be to :

create a copy of the table which has row migration Table A to Table B.
copy migrated rows to new table from Table A to Table B
delete migrated rows from real table Table A
Increase pctincrease parameter Table A
copy rows from Table B into Table A.

Is there an easier way to do this ?

Oracle 8.1.6
SCO Unixware 7

Thanks

Suresh