Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01631, and table is not full, is this an index problem?

Re: ORA-01631, and table is not full, is this an index problem?

From: Stan Brown <stanb_at_panix.com>
Date: 5 Dec 2001 12:27:57 -0500
Message-ID: <9ullet$dfe$1@panix3.panix.com>


>> -- 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 Franklin
Received on Wed Dec 05 2001 - 11:27:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US