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

In <66ts0u0js541nfaot3m142jdp4p467di6q_at_4ax.com> TurkBear <jgreco1_at_mn.rr.com> writes:

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

OK, I see that.

All the tables for this instance (system tables excepted) are created with a fixed initial sze, and no provision for growing, thus there should be no reason for it to attempt to allocate more extents untill it fills the iniital one(s), correct?

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin