Re: Impact of changed index inital extent

You should be using LMT in either auto or uniform mode (your choice). But yes, you can change the storage clause on indexes and tables. Migrate to LMTs and stop trying to follow the 1 extent myth. Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Rogbaker" <Rogbaker_at_gdi.net> wrote in message
news:e40a12ea.0304160619.3b67ca97_at_posting.google.com...


> In my database I have an index that had an INITIAL extent of


> 409,600,000 and a NEXT extent of 5,554,176 but only occupied 1 extent

> due to the extreme size of the inital extent. I was able to alter both

> the INITAL and NEXT extent to 256K but I had to increase the max

> number of extents.  I was suprised that Oracle let me do this, I

> thought I could only change the next, or is that just for tables not

> indexes. It now has 957 extents instead of only one. Is there any

> detremental effect from doing this?

> Thanks for comments,

> Roger