alter table move partition to reclaim storage
I have Oracle Rac 19c db with DB 19.3 on Linux 7.
I have a huge partitioned table that contains alsmot 10 partitions, each partition is populated with almost 10M records monthly and at the end of the month an application process delete almost 90% of this partition keeping some data that cannot be cleared (application specific)
i want to reclaim the storage of these partitions.
I know i could use alter table X move partition (this will move the partition to the same tablespace) is my understanding correct? would the space be reclaimed
what is the impact of performing such activity on an online table would there be any performance impact of doing such