Cleaning up table
Recently, I am trying to remove millions of records from a table using "delete from table" statement . The process is almost done, the daily export backup file looks much smaller. But when I looked at the tabespace , it does not seem to have space back. I believe I must have missed something. After researching, I believe I need to do the following and would like to hear your comments and suggestions of their pros and cons or order in executiing.
alter table xxx dellocate unused;
alter tablesapce xxx coalesce;
alter xxxindex deallocate unused;
Thank you!
Martin