Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center