Oracle Database Discussions

Hi,

I have a table IMAGE with ID number and IMAGE blob columns. Size of this table is 25 GB. I ran an update statement to set the blob to NULL, basically deleting just the image to reclaim some space. After running the update I am unable to see the free space in tablespace, I am not sure why the DBA_FREE_SPACE is not showing the free space which I got after updating 25000 records with around 150K image size each which in total should be around 3.5 GB. Actually I wanna make sure that this will help us adding more images in the same table and I want to see the free space allocated after the update in that BLOB segment. Can anyone please help me finding out what else need to be done in order to get that free space?

Oracle version 10.2 OS: Linux

I am checking the free space using:

select sum(bytes)/1024/1024 from dba_free_space where tablespace_name = 'BLOB_TS';


Thanks
Daljit Singh