Shrinking Tables

spool enable_row_movement.sql

select 'alter table HR.' || table_name||' enable row movement;'

from all_tables

where owner = 'HR'

spool off

spool enable_row_movement.sql

select 'alter table HR.' || table_name||' enable row movement;'

from all_tables

where owner = 'HR'

spool off

spool shrink_space.sql

select 'alter table HR.' || table_name||' shrink space;'

from all_tables

where owner = 'HR'

spool off

spool shrink_space.sql

select 'alter table HR.' || table_name||' shrink space;'

from all_tables

where owner = 'HR'

spool off