-
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?
Thanks
-
-
What will alter index rebuild ... do? Is this the same thing as drop index, then recreate it using new storage parameter?
Thanks again!
-
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.
- Cookies
-
In 7.3.4 rebuild with the PARALLEL option wrecked my indexes - so watch out. Without PARALLEL it workd fine - SO TEST IT FIRST!
-
What will alter index rebuild ... do?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|