Hello,
We have a composite partitioned table (Range Partition and List subpartition), where daily a new partition is at Start of Day (SoD) and the Oldest partition is deleted at End of Day (EoD), thus maintaining 5 partitions + 1 Default partition (Maxvalue).
My concern is, if on a particular day, a new partition is not added, the data shall inserted into default partition. And since, we are not removing the default partition, the data held in it shall keep piling up.
Hence, my question is:
1. Is there a way to find out the data that resides in a particular partition?
2. If we see data is being inserted into Default partition, is there a way to move it into its desired partition (perhaps creating one and then moving)?
Oracle Version:- 10.2.0.5