Oracle database monitoring tool
Home Features Screenshots Download Activate Contacts
 
 
Replacement of partitions by tables (exchange)

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

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 select Save option. Also you can start task immediate by select Run Now option.

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 empty table creation and index rebuild instructions have been generated automatically.

 
www.dbaeasy.com   Copyright © Alexey Brysov 2015 All Rights Reserved.