Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error during insert records to table...
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 Fri Oct 22 1999 - 23:06:18 CDT