One of my tablespace and temp tablespace are almost full, 99.8%. I have autoextend future enabled on both of them. I noticed some unnecessary data in my tables belonging to my tablespace and deleted them assuming this would release free space. But, it didn't and my tablespace file size is at 99.8% limit to its capacity. Does oracle use free space released by the deleted records? When and how the data in temp space deleted?
Thank you very much for all you pointers!