I have created a monthly partition on my table like below:
PARTITION BY RANGE (PARTITION_KEY) INTERVAL(NUMTOYMINTERVAL(1, 'MONTH')) ( PARTITION MayPartition VALUES LESS THAN (TO_DATE('01/06/2016', 'DD/MM/YYYY')) );
Since my table has data in TB, dropping this monthly partition is taking more than 10 hours for 1 month.
Is it possible to drop partition for only 15 days? Or is there a way to reduce the time taken to drop partition?
I made sure there was no other load on database while dropping the partition.
I am using this command to drop the partition:
alter table table_name drop partition partition_name update indexes
I have global indexes on the table. I don't have foreign keys referencing the PK of that table.