URGENT - MAX EXTENTS LIMIT REACHED!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: URGENT - MAX EXTENTS LIMIT REACHED!

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Arrow

    In the alert log the following error occurs,

    ORA-1632: max # extents 50 reached in index
    INV.MTL_UNIT_TRANSACTIONS_N1

    A similar error appears in the client application also, causing a rollback.

    The tablespace on which this index has AUTOEXTEND set to ON, but the ORA erros is that the max extents 50 has been reached.

    How do I overcome this?

    Thanks.

    With regards.


  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi

    you got the concept wrong autoextend refers to the physical datafiles .use alter index rebuild command .......for that index and specify a higher max extents.................autoextend has nothin to do with autoextend ................

    regards
    hrishy

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Thanks for pointing this out.

    I've rectified the error with the following statement

    ALTER INDEX INV.MTL_UNIT_TRANSACTIONS_N1 STORAGE (MAXEXTENTS 75);

    Any suggestions?


    With regards.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ORA-01632 max # extents (string) reached in index string.string

    Cause: An index tried to extend past MAXEXTENTS.

    Action: If the value of MAXEXTENTS in the index storage clause is less than the maximum (based on your block size), raise it. Otherwise, re-create the index with larger extent sizes so that the total number of extents falls below the maximum.




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