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 -> Tablespace usage

Tablespace usage

From: Robert Elbracht <elbracht_at_gce.de>
Date: Mon, 24 Apr 2006 13:19:43 +0200
Message-ID: <e2ic8g$klt$00$1@news.t-online.com>


Hello NG!

I need a statement which results the percentage usage from a tablespace by a schema. The tablespace is used from more than one schema. Is this possibel?

Something like this:

"select usage from tablespace "USER" where schema_name="SCOTT""

Thanks for answers.

Regards Robert Received on Mon Apr 24 2006 - 06:19:43 CDT

Original text of this message

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