Re: Space management for Locally managed tablespaces

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 10 Jan 2003 18:27:01 +1000
Message-ID: <OkuT9.20359$jM5.56173@newsfeeds.bigpond.com>

Hi Simon,

Forgive me if I've misunderstood the question ...

Where to find free space => DBA_FREE_SPACE

Where to find what has used what tablespace => DBA_SEGMENTS / DBA_EXTENTS

But I'm not if this is what you're after ?

Cheers

Richard
"Simon Lenn" <simonlenn_at_yahoo.com> wrote in message news:3641e2c2.0301091648.7e882ec7_at_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 Fri Jan 10 2003 - 02:27:01 CST