Oracle DBA Queries - Database status, uptime, how big is it, etc...
-- -- Shrink Lobs. -- ALTER TABLE &table_name MODIFY LOB (&lob_column_name) (SHRINK SPACE) /