Database Administration (MOSC)

MOSC Banner

table shrink space commands

edited Sep 27, 2019 5:06AM in Database Administration (MOSC) 3 commentsAnswered

Thanks in advance for any info.

I'm using this below to reduce a 6T table.  I've done a heap of deletes so the size should be around 2-3T.

(Using 12.1)

https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm#ADMIN11612

The COMPACT clause lets you divide the shrink segment operation into two phases. When you specify COMPACT, Oracle Database defragments the segment space and compacts the table rows but postpones the resetting of the high water mark and the deallocation of the space until a future time. This option is useful if you have long-running queries that might span the operation and attempt to read from blocks that have been reclaimed. The defragmentation and compaction results are saved to disk, so the data movement does not have to be redone during the second phase. You can reissue the

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