Title: 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
Title: RE: rebuild index -initial extent - magic??!!
If this is true:
The rebuild creates a new temporary segment that is the same size as the
required extents in the old index. If there is insufficient space to create
this temporary segment you get this error.
It doesn't reuse
Remember that initial_extent and next_extent in dba_indexes (and
dba_tables) records what you requested in your storage clause - NOT what
Oracle actually allocated. You need to look at dba_extents for tha.
At 02:34 AM 7/31/2003 -0800, you wrote:
If this is true:
The rebuild creates a new
Title: RE: rebuild index -initial extent - magic??!!
Rebuild will use the same initial extent as it was before but will change
the next extent size. Either drop and recreate index
orYou can also think about using Locally managed Uniform
Extent size tablespace, that way you dont have to worry