lauhin
10/15/2019 - 6:20 PM

Schrink tablespace in Oracle

Schrink tablespace in Oracle

alter table <mytable> enable row movement;
alter table <mytable> shrink space;
alter table <mytable> disable row movement;

analyze table <mytable> compute statistics;
commit;