Re: Free Space - Newbie Question

Hi,

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

gives you a list of free space in megabytes in all tablespaces.

Hth
 Thomas

"Hugo" <Hugo_at_nowhere.com> wrote in message news:<YH_d7.102$Vy6.7720_at_ozemail.com.au>...
> Hi,
>
> I was wondering how I determine how much free space a tablespace has left?
>
> Sean
Received on Tue Aug 14 2001 - 02:36:41 CDT