Database Administration (MOSC)

MOSC Banner

alter table shrink space

edited Jan 20, 2010 1:42AM in Database Administration (MOSC) 20 commentsAnswered
 Hello

I have a table which oracle recommends to shrink via alter table shrink space command (version 10.2.0.3) and release almost all space (46G out of 47 or so). I have not tried this in production yet. From what I read there seems to be no downside to this. The table stays available for reads and updates (the performance will be affected however). The data will not be affected too. And if I have to I can cancel the command in the middle and resume at a later time. Whatever data have been reorged will stay that way.

But am I missing something? Are there any issues with this that others have ran into?

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