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 -> Space management for Locally managed tablespaces

Space management for Locally managed tablespaces

From: Simon Lenn <simonlenn_at_yahoo.com>
Date: 9 Jan 2003 16:48:11 -0800
Message-ID: <3641e2c2.0301091648.7e882ec7@posting.google.com>


hello all

We use Oracle 9i as part of an application we are running the application vendor is asking us to convert all our tablespaces to Locally managed tablespaces. In oracle 8i once a tablespace was set to locally managed there was no way of getting to know the free and used space on the locally managed tablespace (put it this way I do not know of a method to find free and used space for a locally managed tablespace). How can we find the space usage for a locally managed tablespace.

Thanks
Simon Received on Thu Jan 09 2003 - 18:48:11 CST

Original text of this message

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