index, max extents
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: index, max extents

  1. #1
    Join Date
    Jun 2000
    Posts
    315

    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

  2. #2
    Join Date
    Oct 2002
    Posts
    182
    yes.
    - Cookies

  3. #3
    Join Date
    Jun 2000
    Posts
    315
    What will alter index rebuild ... do? Is this the same thing as drop index, then recreate it using new storage parameter?

    Thanks again!

  4. #4
    Join Date
    Oct 2002
    Posts
    182
    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

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    In 7.3.4 rebuild with the PARALLEL option wrecked my indexes - so watch out. Without PARALLEL it workd fine - SO TEST IT FIRST!

  6. #6
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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
  •  



Click Here to Expand Forum to Full Width