I like to insert old partion into a table. For example, partition (P201505) which contains May data needs to be inserted into tmp_table1. But the table already has partitions P201506 and P201507. The script for P201505 is following,
alter table tmp_table1 add PARTITION P201505 VALUES LESS (201506) COMPRESS;
For partitions P201506 and P201507 are following. By the way, these partitions already exist on the table.
alter table tmp_table1 add PARTITION P201506 VALUES LESS (201507) COMPRESS;
alter table tmp_table1 add PARTITION P201507 VALUES LESS (201508) COMPRESS;
Please advise how to insert a old partition P201505 into a table considering that partitions P201506 and P201507 already exist on the table.
So, if you really want to add this partition, you will have to rename the current table, create a new table with the partitions you want, then copy the: data, indexes, constraints and grants from the original table to the new table.