Re: used space

From: root <m.c.bruinsma_at_chello.nl>
Date: Fri, 20 Apr 2001 17:02:10 +0200
Message-ID: <3AE04F72.C94BBE11@chello.nl>

Bastiaan,

As you've stated a number of times in this ng, you're not a DBA, so don't answer questions to which you don't know the correct answer.

Marc Bruinsma
Oracle DBA

Bastiaan Schaap wrote:
>
> You can do a select on the dba_data_files view... This will give you all the
> info you need ;-)
> By creating a view with SUM's you can also use this view to see how much
> space is left in your tablespaces.
>
> HTH,
>
> --
> Bastiaan Schaap
> Desyde BV
> bschaap_at_desyde.nl
> Tel 06 - 51998277
> Fax 035 - 5430547
> http://www.desyde.nl
> ________________________________
>
> make love not war... or get married and do both.
>
> "Ralf Zwanziger" <goldensurfer_at_gmx.de> wrote in message
> news:3acabfa5.2338813_at_news.fth.sbs.de...
> > How can I find out the used space of a datafile? The v$datafile view
> > only shows the total size of the datafile.
> > Thanks,
> > Ralf
Received on Fri Apr 20 2001 - 10:02:10 CDT