You can easily move an object or segment to another tablespace from within the Explorer without launching the Reorg Manager. You can execute the task immediately or schedule it.
To move an object to a tablespace
Tip: You can also perform this action from the search results in the Advanced Search window. Right-click an object in the search results and select Move to Tablespace.
You can easily reclaim space in a segment/object from within the Explorer without opening the Reorg Manager Wizard. The Reclaim Space method performs a live reorganization using the default settings.
You can execute the task immediately or schedule the task in the Reclaim Space dialog.
To reclaim space
Tip: You can also perform this action from the search results in the Advanced Search window. Right-click an object in the search results and select Reclaim Space.
Space Manager allows you to easily resize a datafile using the Datafile Resize wizard. You can launch the wizard from the Explorer after selecting a datafile to resize. Use this feature to resize a datafile prior to creating or running a reorganization script.
Note: Previous releases of Space Manager (8.0.2 or earlier) allowed you to add a "script-pause" option to a reorganization script and use the pause to resize a datafile. Beginning with Space Manager 8.1, the script-pause option is no longer available. This is because its main functionality is superseded by the Datafile Resize wizard. Datafile Resize uses LiveReorg, which is preferable to standard reorganization, the method used with the script-pause function.
To resize a datafile
To decrease size, select Decrease datafile size and click Next. The next page of the wizard displays the available options for resize method and resulting datafile size.
To use the recommended size and to reorganize segments, select Recommended and click Next. This option uses a live reorganization. The next page of the wizard displays the list of segments to be reorganized and several options. Review the following for additional information:
|In Same Tablespace
|Select to leave tables in their current tablespace.
|Move to New Tablespace
Select to move tables to a different tablespace. Then select the new tablespace from the list.
Note: All tables in the list are moved to new tablespace.
|Turn Off Autoextent for Datafile
|Select this option if you do not want this datafile to be autoextensible.
|Drop Datafile if Empty
|Select to drop the datafile if it is empty after a successful reorganization.
After specifying reorganization options, click Next. Schedule the reorganization and resize script.
|Select to schedule the script to run immediately
|Start Job At
|Select to schedule the job to run at a later date and time.
Click Submit Job. The scheduled script displays in the Script/Job Monitor.