Re: what all physical space allocated to my DB's

Thomas Kyte wrote:

> A copy of this was sent to sdua_at_solutionsny.com (Sunil Dua)
> (if that email address didn't require changing)
> On 21 May 2001 10:38:28 -0700, you wrote:
>
> >I have my Oracle database 8.1.5 installed on a sun solaris machine
> >some time ago... I just want to find out what all physical space
> >allocated to the databases installed on it and wether they have
> >sufficient space to continue ... I'll appreciate if you could guide me
> >a bit.
> >
> >thanks a lot.
> >
> >Regards
> >Sunil
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:285415955510
>
> has a script I use called free.sql. It'll show you want you need by tablespace.
>
> --
> Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
> Howtos and such: http://asktom.oracle.com/
> Oracle Magazine: http://www.oracle.com/oramag
> Opinions are mine and do not necessarily reflect those of Oracle Corp

True. But it doesn't completely answer his question as he also needs to know the ability to expand those tablespaces. That is why I suggested df -k. He needs to know where there is space on the drives.

Daniel A. Morgan Received on Sat Jul 21 2001 - 23:41:56 CEST