1. create your partitioned table empty with only one partition as new_table.
OK
2. exchange table target_table with new_table
What do you mean with exchange? Does this also adapt the foreign keys on the target_table to new_table?
3. rename target_table to table_old
OK
4. rename new_table to target_table
OK
Thanks




Reply With Quote