ORA-1631.
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: ORA-1631.

  1. #1
    Join Date
    Jul 2000
    Posts
    147
    Hi.

    I'm getting this error.

    ORA-1631 : max # extents 121 reached in table prod.xxx

    How do I fix it?

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    alter table xxx storage (maxextents unlimited);
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jul 2000
    Posts
    147
    Thanks Jeff.

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Is it advisable to set max extents to unlimited?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Aug 2000
    Posts
    236
    I would suggest looking at LMT's with extent management handled by the system itself.

    There is no problem per se with setting maxextents unlimited; what would you do if you have to store LOB's in the DB itselg.

    Nizar

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Allowing the extents to be handled by the system on an LMT could lead to a fragmentation problem too.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by marist89
    alter table xxx storage (maxextents unlimited);
    This is possible, and can give good result only if database has
    DB_BLOCK_SIZE MORE THEN 2KB. If not, then oracle can't allocate
    more then 121 extents for db objects.

    In this case u should recreate table with more value in NEXT parameter.
    -------------------------------------------
    # of extents depend from DB_BLOCK_SIZE parameters.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Shestakov
    This is possible, and can give good result only if database has
    DB_BLOCK_SIZE MORE THEN 2KB. If not, then oracle can't allocate
    more then 121 extents for db objects.

    In this case u should recreate table with more value in NEXT parameter.
    -------------------------------------------
    # of extents depend from DB_BLOCK_SIZE parameters.
    untrue.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by marist89
    Originally posted by Shestakov
    This is possible, and can give good result only if database has
    DB_BLOCK_SIZE MORE THEN 2KB. If not, then oracle can't allocate
    more then 121 extents for db objects.

    In this case u should recreate table with more value in NEXT parameter.
    -------------------------------------------
    # of extents depend from DB_BLOCK_SIZE parameters.
    untrue.
    UNTRUE.
    I know that exactly, because:
    1) i had this problem a couple years ago with Oracle 8.0.5(may be 8.0.4)
    2) i try to send link about this topic, but not today (this link at home). I hope tomorrow.

  10. #10
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    LINK:
    http://otn.oracle.com/docs/products/...20_io.htm#3480

    Table of # extents (depend from DB_BLOCK_SIZE)

    Block Size (KB) Maximum Number of Extents
    2 -- 121
    4 -- 255
    8 -- 504
    16 -- 1032
    32 -- 2070

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