Re: dba_free_space

Ariel Kirson wrote:
>
> Hello all,
>
> Our company has been using the following query to
> find out how much free space is available for each
> tablespace in our database :
>
> select sum(BYTES)/1024
> from DBA_FREE_SPACE
> where TABLESPACE_NAME = 'TS0';
>
> I am trying to find out how much space is used and how
> much is free for each USER defined in the database.
> Any ideas on how I can do this ?
>
> Thanks in advance,
>
> Ariel Kirson
> Ex Libris.
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Ariel Kirson
The page users/tablespace quotas of our tool Hora 3 shows this information. You can download a free trial version of Hora 3 from

http://www.KeepTool.com.

regards Jan Dieckmann KeepTool GbR
Jan.Dieckmann_at_KeepTool.com Received on Mon May 04 1998 - 14:50:41 CEST