Re: calculate unused space in a datafile

The following script will calculate the free space for all datafiles in your database:

COLUMN file_name FORMAT a60;
SELECT SUM(b.bytes)/(1024*1024)||'Mb' "Free Space", a.file_name FROM dba_data_files a,

     dba_free_space b
WHERE b.file_id = a.file_id
GROUP BY a.file_name;

HTH,
Patrick

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Aug 09 2000 - 00:00:00 CDT