Moving a Partition

Table owners, database owners, or system administrators can move partitions to another segment.

Note: You must set the select into/bulkcopy/pllsort database option to true before you split a partition.

See the Transact-SQL Users Guide for information about partitions.

  1. Expand ASE Servers > Schema Objects > Tables, then choose one of:
    • User Tables
    • Proxy Tables
  2. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, click Partitions.
  4. Click the drop-down arrow and select New, or choose to an existing partition from the right pane.
  5. Click the Name field of the partition, then click the drop-down arrow and select Move.
  6. In the Move Partition dialog, select the destination segment to which to move the partition.
  7. (Optional; only for user tables) Select Enable 'online' mode, which improves concurrency and data availability during the move partition operation
    Enable partition locking must also be enabled.
  8. (Optional) Select Preview to view the new partition information.
  9. Click OK.