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