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: locally managed tbs

Re: locally managed tbs

From: Phillip <tienp_at_wholefoods.com>
Date: Fri, 21 Sep 2001 15:47:56 -0500
Message-ID: <3BABA77B.F9ECC138@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 Fri Sep 21 2001 - 15:47:56 CDT

Original text of this message

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