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.
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?