-
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.
-
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.
-
You might also check to see if there is an insert trigger that is also inserting data into another table.
-
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.
-
How about setting maxextents to unlimited?
Jeff Hunter
-
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.
-
Appearantly it's not obvious, I meant set maxextents to unlimited for ALL OBJECTS.
Jeff Hunter
-
setting for unlimited
How do you set max extents unlimited for all user tables and or objects
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|