Oracle database takes up too much table space. How to reduce the occupied space without deleting the table?
Both alter table name move and alter table name shrink space can be used to shrink segments and reduce high water level HWM.
It can also be used to eliminate row linking and row migration, and the estimated effect is not obvious, depending on what your database is for (it is definitely not obvious if it is a data warehouse).