Re: Locally managed tablespaces

Your right, that was the point. But I checked on it after the move to the locally managed tablespace, and noticied what I thought were inconsistencies. I was hoping someone/anyone would have an explanation for them.

Terry

"Gogala, Mladen" wrote:

> The question is why would you want to do that, anyway? The point
> of a locally managed tablespace is to take the troubles with the
> storage clause away and let you stop defragmenting and start living.
>
> -----Original Message-----
> Sent: Thursday, November 02, 2000 11:36 AM
> To: Multiple recipients of list ORACLE-L
>
> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Nov 02 2000 - 12:49:17 CST