Creating New DBA technology
Home Features Presentations Download Purchase Contacts
Presentations
 
Presentations > Replacement of partitions by tables (exchange)

Choose the table partitions that you want to exchange for tables and select the Exchange partition option from the menu.

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.

Select the necessary options in the partition exchange section 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 table creation and index transfer instructions have been generated automatically!

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