Creating New DBA technology
Home Features Presentations Download Purchase Contacts
Presentaions
 
Presentations > Moving of table partitions and rebuilding of indexes

Select the list of tables (indexes, partitions or subpartitions) in the list of segments and use the context menu (or the SQL Task item in the menu) to choose the Move Segment option.

If there is no active (unfinished) SQL task, create a definition (description) of an SQL task, specify it options and the user whose privileges will be used for running this task. If necessary, you can specify the launch window - the task doesn't start automatically by default.

Specify the necessary parameters in the transfer/rebuilding dialog and press OK.

All SQL expressions required for this process have been generated. If need be, you can view and edit them in the SQL task node.

Note that all transfer instructions have been generated automatically!

The task will be run according to the previously defined schedule or started manually (the Run Now option).

 
www.dbaeasy.com   Copyright © DBA Inventions Ltd. 2008 All Rights Reserved.