From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 3:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: rebuild index -initial extent - magic??!!
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.
