DB version :10.2.0.4.0
OS : SunOS SF40z4196 5.10 Generic_Patch_118844-30 i86pc i386 i86pc
I drop the tablespace using the command
drop tablespace TBS_TEST including contents and datafiles;
The datafile is actually dropped at OS Level after the above command. But the space is not getting released plus
df -h /filesystem_name
still shows the old freespace info.
This is because of some oracle process still holding the file handle.
ML note ID *469731.1* talks about a similair issue. But it says this is not a bug and is the "expected behaviour"
I tried putting the tablespace OFFLINE and then dropping. The changes were reflected after 3-4 minutes. But this "fix" is not working now.
I had to bounce the DB once to fix this. But i still have same issue.
Has anyone faced a similair issue?