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 ?
SCO Unixware 7