Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1631: max # extents 121 reached............
Ashadul Khan wrote:
>
> Hi.
>
> I have a table with 9000 rows. When I tried to insert some record I'm
> getting this error.
>
> ORA-1631: max # extents 121 reached in ..
>
> I alter the table with the storage clause unlimited. But still giving me the
> same error. Any idea what can I do to fix it?
If you can't find it out from the SQL code, look into user_segments.
Uwe
-- Uwe Schneider | Telefon +49 7244 / 609504 Haydnstr. 1 | Mail uwe_at_richard-schneider.de DE-76356 Weingarten | http://www.richard-schneider.de/uwe Linux - OS al dente!Received on Sat Mar 23 2002 - 11:53:13 CST