index, max extents
Hi, I have an 7.2 version database. The max extents is 121.
Now I got error message: ORA-01632: max # extents (121) reached in index XYZ.
Can I just drop the index and recreate it using new initial and next value?
What will alter index rebuild ... do? Is this the same thing as drop index, then recreate it using new storage parameter?
rebuild the index with the proper parameters.
since you are version 7 I don't want to assume what you can and
cannot do in that version.
Size the index correctly but also configure maxextents to a value
so you won't have to do this type of maintenance again.
In 7.3.4 rebuild with the PARALLEL option wrecked my indexes - so watch out. Without PARALLEL it workd fine - SO TEST IT FIRST!
Basically create another version of the same index. Until this 'rebuild' completes the old index will still exist so make sure theres enough space in the index tablespace for both old and new versions.
What will alter index rebuild ... do?
Click Here to Expand Forum to Full Width