Show TOC

alter partitionLocate this document in the navigation structure

Changes the size of a partition.

Syntax
alter partition <logical_name> [expand [size =<size>]]
Parameters
logical_name

A name for the partition. The name must conform to the rules for identifiers. The name is also used in the drop partition and create partition commands.

expand

Specifies that the partition is to increase in size.

size

Specifies the number of megabytes the partition is to increase. The default value is 2MB.

Examples
Example 1
This example increases the size of logical partition <P1> by 50MB:
alter partition P1 expand size = 50
Example 2
This example increases the size of logical partition <P2> by 2MB:
alter partition P2 
Usage
  • alter partition allows users to expand a currently used partition to a larger size. This function is useful when Replication Server needs more disk space and there is still space available in the same disk of the existing partition.

  • In case of insufficient physical disk space, alter partition aborts and an error message displays. The allocated space for the partition is the same as before the command was applied.

  • The maximum size that can be allocated to a partition is 1TB, which is approximately 1,000,000MB.

Permissions

Only the “sa” user can execute alter partition.