Description
The EXCHANGE PARTITION command fails to execute if the partition already exists in the target table. However this is not the expected result from a command named EXCHANGE partition.
Proposed Improvement
Change the command to really exchange the partition between the target and the source table, meaning that after it the source table should have the destination table partition and vice versa.
Documentation EXCHANGE PARTITION