Owner manual

Managing Table Partitions15-16
Assign File Attributes
Use the First Target Specification pane to specify the partition’s file
attributes.
To assign the file attributes
1. In the Extent in Pages pane, perform one of the following:
• To enter the primary and secondary extent sizes, click on
Primary, then enter the primary extent size in the Primary field
and the secondary extent size in the Secondary field.
• To enter the number of extents, click on Extents, then enter the
number of extents in the Extents field.
2. Enter the maximum number of extents in the Max Extents field.
3. Enter the minimum percentage of space to be left in a data block in the
Dslack field.
4. Enter the minimum percentage of space to be left in an index block in
the Islack field.
Enter the minimum percentage of space to be left in data and index
blocks in the Slack field.
Display Dependencies
Before performing a simple move, you can analyze the impact of the
changes:
• To display the programs which depend on the partitions, click
on Dependent Programs. Programs which would be invalidated
by moving the partitions are displayed.
• To display all objects, including programs, which depend on the
table partitions, click on Dependent Objects. All SQL objects
which depend on the table partitions are displayed.
Move the Partition
To perform the simple move, click on one of the following:
• Execute. Executes the command immediately.
• Show. Displays the SQL commands created by dba/m Database
Manager without executing them.