Folks

Oracle 8.1.7
linux

I am not able to understand this equation

see i have a datafile which is 7.5 GB now. I have added so far 6 datafiles to exitsing tablespace with alter tablespace add datafile command.

Now the export backup .dmp FILE SIZE of this schema( only this schema ) comes to almost 3 Gb.

I query this command from view dba_free_space
select sum(bytes)/1024/1024,tablespace_name from dba_free_space group by tablespace_name;
The tablespace FREE space now is 450mb it means that when it reaches almost 50mb i have to add another datafile ' ie 7th datafile'

what u guys suggest.




now my question is will tablespace AUTOEXTEND option help in this scenario.
or
manually adding the datafile will help me - because u see it helps me to monitor the space growth