Tablespace free space
From: Michael Collins <mikecollins_at_cix.compulink.co.uk>
Date: Thu, 9 Jun 1994 21:53:37 GMT
Message-ID: <Cr5GtD.35C_at_cix.compulink.co.uk>
Date: Thu, 9 Jun 1994 21:53:37 GMT
Message-ID: <Cr5GtD.35C_at_cix.compulink.co.uk>
> ==========
Dave,
In reply to ...
>
> Message-ID: <2t73u3INNoqq_at_turtle.cis.ohio-state.edu>
>
>
> How can I find out how much free space I have left in a tablespace?
> I have Oracle 6 on a Sun running Solaris...
>
SELECT round(sum(bytes)/1024) kbytes
FROM sys.dba_free_space
WHERE tablespace_name = '<enter tablespace name here>'
/
- From the amazing PC of ----------- MikeCollins_at_cix.compulink.co.uk or MMCOLL_at_ccmail.monsanto.com ( DBA, Designer, A/P, etc. etc )