what happen to the free blocks when we delete data from a table ?
Hi Experts,
I have deleted around 100GB of LOB files from a table. but still getting error to extend the tablespace. Do the free space reused by the table ?
How can I reuse the free space by the same table?
My DB Version is: 11.2.0.3 - SE1
OS: Windows 2008R2
Tablespace Type: BIGFILE (All LOBs of the schema are stored in this tablesapce)
recycle bin is also empty.
SQL> select count(*) from dba_recyclebin;
COUNT(*)
----------
0
Please help with some advise.
Thank You.