Hi,
version 11.2.0.3
Have interval partitioned table and was trying to remove some old data and got ORA-014758 cannot remove last range partition
NO - indicates range partition, yes indicates interval partition
partition_name, partition_position, interval
PART_201312 1 NO
PART_201401 2 YES
PART_201402 3 YES
PART_201403 4 YES
PART_2014_04 5 YES
Understand cannot drop the range parttion (i.e. PART_201312) but wanted to make sure if say drop partitions PART_201401, PART_201402, PART_201403 then wanted to check no adverse impact of keeping the PART_201312 range partition and removing say PART_201401, PART_201402
i.e. Questions is it possible to drop interval partitions in range interval partitioned table but keeping older partitions in table?
We could run a delete on the PART_201312 data and whilst maybe not the tidiest keeping the empty PART_20132 partition would maintain all existing data form PART_201403 onwards with equal sized partition.
Not looking practical for us to switch off interval partitioning, drop PART_201312 and then switchback on as have as few partitions e.g PART_202206, PART_202210, PART_400012 which have rows in and don't want new rows e.g. for 2023, 2024 etc to will go into the PART_400012 partition as understand when switch interval partitioning back on the intervals start from the highest range point.
We have several years worth of data with each month having similarly sized partitions and partitions being created automatically
Thanks