Partition management option to rename a partition of a partitioned table.

Syntax

proutil db-name -C partitionmanage rename partition table-partition-name
  partition new-table-partition-name

Parameters

db-name
Specifies the database where you are performing partition management.
partition table-partition-name
Specifies the current name of the existing partition to rename.
partition new-table-partition-name
Specifies the new name of the partition. The name must not exist in the database prior to executing this RENAME command.

The new-table-partition-name must follow the standard rules for partition naming. The name:

  • Must be unique; it cannot already exist in the database
  • Must be 32 or fewer characters
  • Can only contain the following characters: a-z, A-Z, 0-9 (ASCII) , and the special characters::# $ % & - (dash) _ (underscore)
  • Is not blocked from using reserved words (as the database does for table names)

Notes

  • You can not rename the composite initial partition of a table.
  • You can not rename a partition that is the source of merge operation. PARTITIONMANAGE RENAME checks the object state of the partition, and if it is involved in a merge, the rename is denied.
  • PARTITIONMANAGE RENAME can be performed when the database is online or offline.
  • If RENAME is executed while the database is online, it is possible that other partition operations (both language clients and utilities) could report the name change during execution. For example, DBANALYS could possibly report both the original and renamed partition names.