Oracle-L: RE: rebuild index -initial extent

From: <Avnish.Rastogi_at_providence.org>
Date: Thu, 31 Jul 2003 08:29:26 -0800
Message-ID: <F001.005C7FF5.20030731082926@fatcity.com>

Rebuild will use the same initial extent as it was before but will change the next extent size. Either drop and recreate index or You can also think about using Locally managed Uniform Extent size tablespace, that way you dont have to worry about specifying initial and next extent.

-----Original Message-----
[mailto:Paula_Stankus_at_doh.state.fl.us]
Sent: Thursday, July 31, 2003 3:19 AM
To: Multiple recipients of list ORACLE-L

I did the following in Oracle RDBMS 9i:

SQL> alter index xsc_uk rebuild tablespace ax_le_small storage (initial 128K 2 next 128K);
SQL> select initial_extent,next_extent,index_name from dba_indexes 2 where index_name like 'XSC%';

         65536      131072 XSC_CLNT_FK_I 
         65536      131072 XSC_PK 
        131072      131072 XSC_UK 
_________________________________________________________________________________

As I wish to use uniform extent sizing and I was given an import that does have that. I am a little concerned about the initial extent changing - what if there is data in the index? - how it could possibly deallocate space if you wish to have a smaller extent size. It was very quick. Did I really end up with new extents for XSC_UK each 128K????

DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <Avnish.Rastogi_at_providence.org
INET: Avnish.Rastogi_at_providence.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Jul 31 2003 - 11:29:26 CDT

RE: rebuild index -initial extent - magic??!!