CODE EXAMPLE FOR SQL

oracle free up space in tablespace

ALTER TABLE my_table ENABLE ROW MOVEMENT;
ALTER TABLE my_table SHRINK SPACE;