Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: locally managed tbs
The data dictionary tables should give you the information you need because
the data dictionary tables are actually a view which give a union of
information from tables that are and are not locally managed
Phillip <tienp_at_wholefoods.com> wrote in message
news:3BABA77B.F9ECC138_at_wholefoods.com...
> oh forget it, I found the reason. The tablespace in question was set to
> autoallocate. If it was set to a uniform size, then it'd show up under
> dba_tablespaces.
>
> Phillip wrote:
>
> > got a quickie...since locally managed tablespaces aren't stored on the
> > data dictionary, how can I find out basic info on it like next_extent
> > size? When I do a query on a locally managed tablespace through the
> > view dba_tablespaces, no value is returned. Please copy
> > tienp_at_wholefoods.com in responses. Thanks.
> >
> > --
> > Phillip
>
> --
> Phillip
>
Received on Sun Sep 23 2001 - 17:03:58 CDT