deleted table's space available after a large protion of the table's record is delete


Which is the best method to recover space from a table whose records have been delete (not all say 10% records ) and the table is not a partitioned one.

will alter table deallocate unused help.

its a very big table.