I performed a delete operation on my table . It deleted around 10 millions of rows from it
How do I free the space associated with the deleted data.
I used the query:
alter table tablename shrink space;
But it did not work for me. Do I need to concern about the index's associated with the table?
If that is the case, how do I need to do it.