Re: Need Help

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Mon, 15 Nov 1999 08:09:25 +0100
Message-ID: <80objo$13n0v$1@fu-berlin.de>

Hi,

the following should be what you want? Why do you want to join with dba_data_files?

Hope that helps,

Bye
Uli

select tablespace_name, sum(bytes)/1024 size_left_in_kB from dba_free_space group by tablespace_name
having sum(bytes)/1024 < 100

couger <couger_at_ix.netcom.com> schrieb in im Newsbeitrag: 80nbs3$3l3$1_at_nntp2.atl.mindspring.net...
> i am trying to write a sql script to generate a tabular report for
> tablespaces that have less than 100k free space (reqires dba_free_space
> joined with dba_data_files)
> can somebody help.
> thanks
>
>
Received on Mon Nov 15 1999 - 01:09:25 CST