Page 1 of 1

Drop or merge tablespace partitions

PostPosted: Thu Sep 11, 2008 3:44 pm
by markokop
Hi all,

is it possible to drop or merge particular tablespace partitions?
I need to reduce number of partitions.

Re: Drop or merge tablespace partitions

PostPosted: Thu Oct 16, 2008 2:28 am
by satyender
Hi,
Try the option "DETACH PARTITION".

In this example, the dec01 data partition is detached from table stock and placed in table junk. You can then drop table junk, effectively dropping the associated data partition.


ALTER TABLE stock DETACH PART dec01 INTO junk;
DROP TABLE junk;