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

Thread: max extents reached

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Posts
    16

    max extents reached

    I am receiving the following message ORA-01631 . I have increased the max extents to unlimited and performed percentage increases on the tablespace. I am trying to import data into a particular table not from a Oracle dump file but from another database. Is there anything I can check or modify further in Oracle as I am still receiving the max extents reached message when data is imported.

    ORA-01631 max # extents (string) reached in table string.string

    Cause: A table tried to extend past MAXEXTENTS.

    Action: If MAXEXTENTS is less than the system maximum, raise it. Otherwise, you must re-create with larger initial, next or PCTINCREASE parameters.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    Are you sure this is not for the table index?
    I have seen that before.
    I would not touch the pct_increase for the table, IMO, you are asking for trouble.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You might also check to see if there is an insert trigger that is also inserting data into another table.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by gandolf989
    You might also check to see if there is an insert trigger that is also inserting data into another table.
    Very good call, I had that happen once!!
    I hate when that happens!

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    How about setting maxextents to unlimited?
    Jeff Hunter

  6. #6
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by marist89
    How about setting maxextents to unlimited?
    How about reading sentence one, paragraph one.
    Two steps back my arse!

    MH
    I remember when this place was cool.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Appearantly it's not obvious, I meant set maxextents to unlimited for ALL OBJECTS.
    Jeff Hunter

  8. #8
    Join Date
    Nov 2002
    Posts
    16

    setting for unlimited

    How do you set max extents unlimited for all user tables and or objects

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: max extents reached

    Originally posted by bal
    I have increased the max extents to unlimited and performed percentage increases on the tablespace.
    Setting MAXEXTENTS to unlimited on the tablespace level has absolutely no effect on the existing segments (as well on the future segments that will have MAXEXTENTS specified sxplicitely). You'll have to set MAXEXTENTS on the table you are inserting to.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Jan 2001
    Posts
    3,134

    Re: setting for unlimited

    Originally posted by bal
    How do you set max extents unlimited for all user tables and or objects
    SQL> SET HEADING OFF
    SQL> SET PAGESIZE 1000
    SQL> SPOOL MAX_EXTENTS_UNLIMITED.SQL

    SQL> select 'alter table '||owner||'.'||table_name||' storage(maxextents unlimited);'
    2 from dba_tables
    3 where owner='TABLE_OWNER_YOU_WANT_TO_ALTER;

    SQL> SPOOL OFF


    Who do you love?

    MH
    I remember when this place was cool.

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