Altering partitions – HP NonStop G-Series User Manual

Page 217

Advertising
background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005

15-11

Altering Partitions

Use the Alter partition pane to modify the file attributes of a partition. To
alter a partition, click on Table Partitions in the Main window, then click
on Alter. The Alter Partitions window will be displayed, as shown in Figure
15-7.

Figure 15-7. Alter Partitions Window.

To alter a partition

1. Click on the name of the partition you want to alter in the partition

name and catalog pane.

2. To change extent allocations, perform one of the following:

•

To allocate extents, click on Allocate then enter the number of
extents in the Allocate field

•

To deallocate unused extents, click on Allocate to remove the
checkmark.

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

Advertising