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

June 7, 2008. Uncategorized.

No Comments Yet

Be the first to comment!

Leave a Reply

Trackback URI