RE: Locally managed tablespaces

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-----
From: Jared Still [mailto:jkstill_at_bcbso.com] Sent: Thursday, November 02, 2000 11:36 AM To: Multiple recipients of list ORACLE-L Subject: Re: Locally managed tablespaces

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).