Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Querying tablespace size

Re: Querying tablespace size

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 03 Mar 2005 17:26:05 -0800
Message-ID: <1109899376.101987@yasure>


elnegro wrote:

> Hi all,
>
> do you know how can I get the size of all the tablespaces and the free
> space for each one? Obviously through PL/SQL. The main idea is to avoid
> Enterprise Manager. I´m trying to get the same info through PL/SQL.
>
> Thenks,
> Best regards.
> Pablo.

I just posted two queries to do this yesterday.

Since you didn't find them go to:
http://www,psoug.org
click on Morgan's Library
click on Tablespaces
scroll down

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Mar 03 2005 - 19:26:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US