Re: used space

From: Bastiaan Schaap <bschaap_at_desyde.nl>
Date: Wed, 4 Apr 2001 10:34:09 +0200
Message-ID: <kXAy6.12$HW.649@psinet-eu-nl>

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 Wed Apr 04 2001 - 03:34:09 CDT