Database Administration (MOSC)

MOSC Banner

If "alter table .. shrink space" is cancelled, has this command done anything, or it resets everythi

edited Feb 7, 2019 2:53PM in Database Administration (MOSC) 5 commentsAnswered ✓

Hi

Oracle 12.1.0.2.0

When doing the following (and the table is quite big, lets say it takes 3 hours to complete), and at some point, lets say when 1 hour has passed, I have to cancel this operation, does this mean, that when I execute the same command again, will it start from scratch..?

(meaning will the same command take 3hours or 2hours to finish at that point)

"ALTER TABLE ... SHRINK SPACE (CASCADE);"

Regards

Raul

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