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
/

Moving Partitions Containing LOBs

You can move a LOB partition into a different tablespace. This is useful if the tablespace is no longer large enough to hold the partition. To do so, use the 
ALTER
TABLE ... MOVE PARTITION
clause. For example: 
ALTER TABLE current_table 
MOVE PARTITION partition_name
TABLESPACE destination_table_space
LOB (column_name) 
STORE AS (TABLESPACE current_tablespace);