Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Max Extents reached

Re: Max Extents reached

From: Cecília Oliveira <ceciliaoliveira_at_cmvm.pt>
Date: Mon, 5 Jul 1999 11:47:14 +0100
Message-ID: <7lq2e4$o5u$1@duke.telepac.pt>


You must recreate with larger initial, next or pctincrease parameters...

Greg Akins wrote in message <930837721.23411_at_www.remarq.com>...
>I am updating a table and get the following error.
>
>ERROR:
>ORA-01631: max # extents (50) reached in table
>DEVADMIN.MASTER_CLAIM
>
>The thing is, the (table, tablespace, datafile) all seem to
>be defined with plenty of room. And the max number of
>extents on the table is set to 100.
>
>Can anybody provide me some insight. Or at least
>suggestions of where to look.
>
>-greg
>
>
>
>
>**** Posted from RemarQ - http://www.remarq.com - Discussions Start Here
(tm) **** Received on Mon Jul 05 1999 - 05:47:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US