How to reclaim the space after delete
883404Aug 30 2011 — edited Aug 30 2011Hi All,
Today we deleted large number of rows from one table, but we didn't get free space after that. So for testing purpose, I have created one test tablespace with 5mb size .Created a table and inserted n number of rows in that table and made the tablespace full.I checked in dba_segments(5mb) and dba_free_space tables.It shows perfectly.After that I deleted all the records and try to create a simple table,but it returns (ORA-01658: unable to create INITIAL extent for segment).I read some time back in tom's forum that delete willn't reclaim the space ,instead it will go to freelist of table..Is there any way to reclaim the space?(after delete)
and also I used to see the tablesize by using dba_segments table.but now it shows 5mb of size for the empty table.Is there any query to get the exact table size?Please help me to understand the concept.
Thanks,Jvel