Database Tuning (MOSC)

MOSC Banner

How can we reclaim space after deletion in table which has huge size

I have tried to delete rows from a table which is 240 GB of size. Almost 5 GB of data is deleted, but DB space is not reclaimed. Have performed Table movement online. but the same is taking long time and generating huge amount of database.

Is there anyway that we can reclaim space without much time and stopping archivelog generation during table movement online

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