Partitioning Tables  «Prev  Next»

Manipulating Partitions in Oracle

The code you create to
  1. move a partition to a different tablespace,
  2. merge two partitions into one, and
  3. rename a partition
should look something like this:

ALTER TABLE WHOLESALE_ORDER
MOVE PARTITION LOW_PART TABLESPACE LOW_PART_TS
/
ALTER TABLE WHOLESALE_ORDER
MERGE PARTITIONS
LOW_PART, MED_PART 
INTO PARTITION LOW1_PART
/
ALTER TABLE WHOLESALE_ORDER
RENAME PARTITION LOW1_PART TO LOWEST_PART
/