From: "Bastiaan Schaap" Newsgroups: comp.databases.oracle.server References: <3acabfa5.2338813@news.fth.sbs.de> Subject: Re: used space Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 Message-ID: Date: Wed, 4 Apr 2001 10:34:09 +0200 NNTP-Posting-Host: 195.81.33.156 X-Complaints-To: abuse@uk.psi.com X-Trace: psinet-eu-nl 986372944 195.81.33.156 (Wed, 04 Apr 2001 09:29:04 BST) NNTP-Posting-Date: Wed, 04 Apr 2001 09:29:04 BST Organization: Connectivity but not content by PSINet 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@desyde.nl Tel 06 - 51998277 Fax 035 - 5430547 http://www.desyde.nl ________________________________ make love not war... or get married and do both. "Ralf Zwanziger" wrote in message news:3acabfa5.2338813@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