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

Re: Space management for Locally managed tablespaces

From: Simon Lenn <simonlenn_at_yahoo.com>
Date: 10 Jan 2003 04:25:50 -0800
Message-ID: <3641e2c2.0301100425.1abfdba5@posting.google.com>


Hi Richard

But I cannot see free space and space used from DBA_SEGMENTS and DBA_FREESPACE for LMTS I can see for DMTS but not for LMTS that was why I raised the question.

Thanks
Simon
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<OkuT9.20359$jM5.56173_at_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 - 06:25:50 CST

Original text of this message

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