Shrink Table

To shrink an object

ALTER TABLE employees SHRINK SPACE [CASCADE]

To shrink a LOB (must be issued separately since SHRINK SPACE CASCADE does not cascade to LOB)

ALTER TABLE employees MODIFY LOB(resume) (SHRINK SPACE)

Shrink the overflow segment of an Index Organized Table (IOT)

ALTER TABLE employees OVERFLOW SHRINK SPACE
Advertisements