I loaded up a 490M file into a database and turned out at that I was only left with 10% of free space on that mount point.
Now when I did a delete from dbname;
Even though the data got deleted, the hard drive still showed only 10% of space remaining.
What could have gone wrong??
Ive got Oracle running on a Linux box and I do a df to see me how much space is left.
I sometime ago moved the database from mount point /u01 to /u02 and updated the log and control files to point to files in the new mount point and it went smooth. Got I have missed something that somehow is causing the problem?
THanks.