We use Oracle 9i. I have to create a new tablespace with an underlying new data file of 500 MB. I do not know how much free database size available.
I gave the command
select sum( bytes / ( 1024 * 1024 ) ) from dba_data_files;
and got 5145
So I think that means 5 GB of space is occupied by existing data files.
How do I know the maximum space I can allocate to this new datafile ?