Re: How to check free space left in tablespace

select sum(bytes)
from sys.dba_free_space
where tablespace_name = 'xxx'

Where xxx is the name of the tablespace you are interested in.

Ken

The Chuckster wrote:

> How can I see how much free space is left in a tablespace/datafile?
>
> Thanks,CC
Received on Fri Aug 06 1999 - 13:02:17 CDT