Creating New DBA technology rus | eng
Home Features Presentations Download Purchase Contacts
Presentations
 
Presentations > Adding new partitions (split)

Set partition properties for default splitting. You just need to do it once, modification is necessary only if partitioning rules are changed. You should also specify the warning threshold for the number of free partitions.

Choose the table partition that you want to split through the user’s or tablespace segments (usually thus section has the MAXVALUE parameter).

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 split 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.

 
www.dbaeasy.com   Copyright © DBA Invention Group 2007 All Rights Reserved.