| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01631, and table is not full, is this an index problem?
>> -- Benjamin Franklin
>Did you read the text of the error message? Use the 'oerr' command at
>the UNIX prompt. This will give you the cause of the error and the
>solution.
$ oerr ORA 01631
01631, 00000, "max # extents (%s) reached in table %s.%s"
// *Cause: A table tried to extend past maxextents
// *Action: If maxextents is less than the system maximum, raise it.
Otherwise,
// you must recreate with larger initial, next or pctincrease
params
If you _read_ the original post, you will see that I clearly know what the message is saying, and it's clearly not correct. That's why I asked for some help.
As you can see from the data in the original post, there is free space in the existing extents for this table, therfore it should not need to get more extnts.
Or am I missing somehting here?
-- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin FranklinReceived on Wed Dec 05 2001 - 11:27:57 CST
![]() |
![]() |