Re: Error during insert records to table...

From: Patrick Hamou <patrick_hamou_at_hotmail.com>
Date: Sat, 23 Oct 1999 04:06:18 GMT
Message-ID: <_uaQ3.22679$up3.29517@news21.bellglobal.com>

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