Administration Workshop II 11-20. Shrinking Segments by Using SQL
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
No Comments Yet
Be the first to comment!