We have deleted records from big tables in database. But each table still holds the same blocks and extents. It means they have not released the space logically. How to use this space.

Let us see the steps.

Example: I have created a table TEST_TABLE from emp and inserted many records to occupy many database blocks […]