remove unused space in a table

remove unused space in a table

a) alter table xxx shrink space compact;
b) alter table xxx deallocate unused space; 
c) analyze table xxx compute statistics; 
d) exec dbms_stats.gather_table_stats (....... );
e) alter table xxx coalesce;



example:


alter table uday shrink space compact;
alter table uday deallocate unused space; 
analyze table uday compute statistics; 
exec dbms_stats.gather_table_stats (uday);
alter table uday coalesce;