Why Free space in dba_segments and dba_indexes are unchanged even after deleting rows?
DB 10.2.0.3, on AIX
We have deleted a lot of rows in a table but when I compare the output of the uploaded script which is used to calculate the size of table and indexes before and after the delete, nothing has been changed (even a gather table statistics has been run) except total of rows in the table has been decreased. I have tried to used dbms_space.unused_space, it gives the same result. Why ? Does it exist another way to know how many space (in Mb)has been freed by deleting rows in my table.
First script :
col r_owner format a7 heading 'Schema'
We have deleted a lot of rows in a table but when I compare the output of the uploaded script which is used to calculate the size of table and indexes before and after the delete, nothing has been changed (even a gather table statistics has been run) except total of rows in the table has been decreased. I have tried to used dbms_space.unused_space, it gives the same result. Why ? Does it exist another way to know how many space (in Mb)has been freed by deleting rows in my table.
First script :
col r_owner format a7 heading 'Schema'
0