Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Error during insert records to table...
Hello Patrick,
I want to ask, is it possible to set the maxextents to some very large value? (e.g. 10000) Is there any disadvantage to set maxextents to very large value? Or any limit to set the value of maxextents? And what is the use of MAXEXTENT parameter in creating the table?
David
Patrick Hamou wrote:
> Hi !,
>
> Well the problem is quite simple, youve reached the Maxextent value for your
> table (witch is by the way
> the default maxextents value for Oracle 7)
> To solve the problem, you have to recreate the table with larger Extents and
> (or) set the Nomaxextent
> parameter for your table if you have Oracle 8...
>
> regards,
>
> Patrick Hamou,
> Oracle DBA
> patrickhamou_at_hotmail.com
>
> David <david_petit_at_yahoo.com> wrote in message
> news:3811FF38.C8866C79_at_yahoo.com...
> > Hello all,,
> >
> > When I insert rows to the table, I got the following error message:
> >
> > ERROR at line 1:
> > ORA-01631: max # extents (121) reached in table USER.TESTING
> >
> > Could anyone tell me why such an error message shown and how to
> > solve this problem?
> >
> > THanks,
> > David
> >
Received on Sat Oct 23 1999 - 22:03:25 CDT