No more hard drive space!

[trogen]

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.

[kmesser]

The tablespace still contains that disk space. Resize the tablespace/datafile.

[trogen]

How can I do that?
Could you provide me with a sample sql code for clarification?
Thanks.

[brhynold]

ALTER DATABASE DATAFILE 'path and datafile name' RESIZE XXX M(size to resize to)

Ex:

ALTER DATABASE DATAFILE 'C:\ORADATA\TEST.DBF' RESIZE 10 M

[trogen]

When I try to give it a value smaller than the one that is set, it gives me an error message that file contains used data beyond requested RESIZE value.
When I checked the database to make sure, the tables are all empty.
What could be the problem?

[sambavan]

drop those empty tables and then issue the resize, it should work o.k.

Sam