hi,

Generally whenever we create a tablespace OR add a datafile, we keep autoextend off. 'Cause it will keep on increasing and you OS will start giving error at one time.

So use some gui tools like SQL Navigator or DBTools to see how much your tablespace is filled.