Creating New DBA technology
Home Features Presentations Download Purchase Company
Presentations
 
Presentations > Adding new partitions (split)

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

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. Split interval and start value defined automatically in case of all data about this object collected and its default options saved in repository.

Select Save option or 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.

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