Database Administration (MOSC)

MOSC Banner

How use Shrink Space for Partition tables

edited Jul 4, 2022 3:15PM in Database Administration (MOSC) 6 commentsAnswered

Please let us know how to shrink space of partition table as after running segment advisory on table i found many table partition that has showing "Perform shrink, estimated savings" .

Such as:

SEGNAME          PARTITION                TYPE         MESSAGE

------------------------- ---------------------------------------- -------------------- ------------------------------------------------------------

SEGNAME          PARTITION                TYPE         MESSAGE

------------------------- ---------------------------------------- -------------------- ------------------------------------------------------------


Thanks

Ran Vijai

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