Exchange table partition
In Oracle, partitioning-related clauses for ALTER TABLE
can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance.
The following SQL swaps data with the partition P1 in two tables:
Result:
Last updated