Database Tuning (MOSC)

MOSC Banner

Cleaning up table

edited Apr 9, 2013 7:11AM in Database Tuning (MOSC) 4 commentsAnswered ✓
Hi,

Recently, I am trying to remove millions of records from  a table using "delete from table" statement .  The process is almost done, the daily export backup file looks much smaller.  But when I looked at the tabespace , it does not seem to have space back.  I believe I must have missed something.  After researching, I believe I need to do the following and would like to hear your comments and suggestions of their pros and cons or order in executiing.

alter table xxx dellocate unused;

alter tablesapce xxx coalesce;

alter  xxxindex deallocate unused;

Thank you!

Martin

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