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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center