Move Partitions

Use alter table ... move partition to move a partition (and its index) to a specified segment.

The syntax is:

alter table table_name
move partition partition_name 
to destination_segment_name

where:

partition_name – the partition you are moving.
destination_segment_name – a new or existing segment to which you are moving the partition. You cannot specify “default” as the destination_segment_name.

See the Reference Manual: Commands.

You must enable select into/bulkcopy to issue alter table ... move partition.