Database Tuning (MOSC)

MOSC Banner

alter table shrink space compact/shrink space

edited Apr 10, 2013 12:02PM in Database Tuning (MOSC) 6 commentsAnswered ✓
Hi,

I am planning to run the following scripts to release space in a table that has been heavily cleaned up by 'delete ..' statement.

However, I wasn't sure if I should run

 "alter table .. shrink space compact' and then  "alter table .. shrink space '

or just use

 "alter table .. shrink space compact'

The database version we have now is 10g, but eventually, I will run the script on 11g database also.  I also wonder if I need to have concerns on indexes that  associated with the tables being 'shrink'.

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