Oracle-L: Re: pct increase

From: Goran V <goranv_at_edb.eps.co.yu>
Date: Mon, 13 Oct 2003 23:49:26 -0800
Message-ID: <F001.005D2F7D.20031013234926@fatcity.com>

Hi!

You have to change the 'next extent' value for the table to make it fit into available free space. Oracle will calculate the next extent size based on both new value of 'pctincrease = 0' and current value of 'next extent' which is still 520 MB and there's no chunk that big. I believe this could solve the problem, but still you have to consider increasing the tablespace size and / or defragmenting the table by doing export (+ merge extents for import) / import of the table. Take care of ref. integr. constraints, indexes...

Bye
  . ----- Original Message -----
  From: AK
  To: Multiple recipients of list ORACLE-L   Sent: Monday, October 13, 2003 6:19 PM   Subject: pct increase

Hi List ,
I have a table set with pctincrease 50. After growing many times now it is asking for 520M of disk space and I dont have that much space in dba_free_space . Now I want to change pctincrease to 0. So that it doesn't have spiraling requirement . But event after changing pctincrease to 0 this table is still coming in my list of monitored exntents which doesn't have room for next growth. Question is , when does oracle calcs next space requirement ? It looks like its precalculated .

-ak

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Goran V
INET: goranv_at_edb.eps.co.yu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 14 2003 - 02:49:26 CDT