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. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
  2. Expand ASE Servers > Schema Objects > Tables, then choose one of:
    • User Tables
    • Proxy Tables
  3. Select the table for the partition.
  4. Select Properties.
  5. Select Partitions.
  6. Click the partitions to move and select Move.
  7. Select the destination segment to which to move the partition.
  8. (Optional) Select Preview to view the new partition information.
  9. Click OK.
Parent topic: Manage Partitions