You can use Oracle Enterprise Manager to reorganize database space usage and to change an object's storage settings and location. The Reorganize Objects wizard evaluates the reorganization operations and generates an Impact Report which can be reviewed prior to execution. You can use the wizard to rebuild fragmented indexes or tables, move objects to a different tablespace, or optimize the storage attributes of specified objects.
To reorganize objects, follow these steps:
Navigate to the Database Home page.
On the Schema tab, click Reorganize Objects in the Database Objects section.
The Reorganize Objects wizard appears which walks you through the process selecting the objects and customizing the options for the reorganization job. Finally, you can review your input and start or schedule the gather statistic task.
Click Help for more information about reorganizing objects.
Enterprise Manager Information Roadmap
Copyright © 1996, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.