Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Max # extents reached
Maybe I don't understand your question, but you can't insert jack into a table
that has no more room. Why not re-create the table to allow it some room for
growth? or increase the maxextent size?
Regards,
Satar Naghshineh
In article <6valru$m4n$1_at_nnrp1.dejanews.com>,
adiska_at_my-dejanews.com wrote:
> I am using Personal Oracle 7.3.3.0 for Windows NT and I have developed an
> application. I would like to update a field from 0 to 1 after an operation
> is completed. This works fine most of the time, however during stress
> testing I filled the table completely full and tried the update. I was told
> that I could update an existing value (a non-null value) even if the table
> was full. However I did recieve the error ORA-01631: max # extents reached in
> table. It is important to always update this value, even if the table
is
> full.
>
> Is it possible to update a single value, even if the table is already full?
> Does it matter, that the value I am trying to reset was initially set to an
> automatic default value when the row was created?
>
> Thank you in advance.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 06 1998 - 13:46:03 CDT