Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Locally managed tablespaces

Re: Locally managed tablespaces

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Thu, 02 Nov 2000 11:04:26 -0600
Message-Id: <10668.120983@fatcity.com>


I realize I can specify the initial and next. I am mostly wondering why the initial would show up as the old size, but the bytes in dba_extents would show ONLY as the uniform size.

Terry

Jared Still wrote:

> On Thu, 2 Nov 2000, Terry Ball wrote:
>
> > I created a locally managed tablespace (to be used for indexes). I then
> > issued an alter index rebuild command specifying the new tablespace as
> > the destination (without using a storage clause). The rebuild went OK,
> > but when I checked the initial and next for the index (in dba_indexes
> > and dba_segments) it shows it as having an initial extent the same as it
> > was before the move. Looking in dba_extents, all extents associated
> > with the index are the correct size.
> >
> > Why does dba_segments and dba_indexes show an incorrect initial extens?
> > Is it necessary to specify the storage clause to see the correct initial
> > extent?
> >
>
> Terry,
>
> You can specify an INITIAL and NEXT extent size with LMT's. Oracle treats
> it differently than with a DD managed tablespace though. If you have an
> LMT with 128K uniform extent sizes, and you create an object with an INITIAL
> extent size of 512K, Oracle will record the INITIAL as 512k, and create the
> object with 4 extents to satisfy the 512k you asked for.
>
> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;-)
> Regence BlueCross BlueShield of Oregon
> jkstill_at_bcbso.com - Work - preferred address
> jkstill_at_teleport.com - private
Received on Thu Nov 02 2000 - 11:04:26 CST

Original text of this message

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