Re: How to check free space left in tablespace

The Chuckster <ccarson_at_phi.org> wrote in message news:37ab1c7c.240604460_at_client.nw.news.psi.net...
>
>
> How can I see how much free space is left in a tablespace/datafile?
>
> Thanks,CC

To find out the free space in tablespace, use this:

select tablespace_name, sum(bytes)
  from dba_free_space
  group by tablespace_name;

To find out the free space in datafile, use this:

select d.file_name, sum(f.bytes)
  from dba_free_space f, dba_data_files d   where d.file_id=f.file_id
  group by d.file_name; Received on Sun Aug 08 1999 - 10:35:03 CDT