To exchange a partition of a range, hash, or list-partitioned table with a nonpartitioned table, or the reverse, use the
PARTITION statement. An example of converting a partition into a nonpartitioned table follows. In this example, table
stocks can be range, hash, or list partitioned.
ALTER TABLE stocks EXCHANGE PARTITION p3 WITH TABLE stock_table_3;