Database Administration (MOSC)

MOSC Banner

How to manage old table partitions

edited Sep 18, 2018 5:01AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi all,

I would want to get some input on what's the best strategy in handling databases which have a lot of table partitions.

I have a database which uses range partitioning by date, so now I have tablespaces which dated back in 2010.

What is the good approach to housekeep these so I could reuse back all the spaces allocated to the old tablespaces instead of assigning new storage to the server.

One idea which I could think of is to export dump the DB and drop the old partitions.

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