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

The free blocks and the maxextents are not related ( at least not in your situation)

It is not clear from your initial posting,or your followup, what the MAXEXTENTS for that table is... The error is specific to the # of your extents not their size....As it states, if your maxextents is at the max allowed for your system then the only solution is to rebuild the table with new parameters...

stanb_at_panix.com (Stan Brown) wrote:

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

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Wed Dec 05 2001 - 13:30:54 CST