-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|