| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: pct increase
you will find the answer in the docs under 'alter table'
pay particular attention to the 'storage' clause
Jared
"AK" <oramagic_at_hotmail.com>
Sent by: ml-errors_at_fatcity.com
10/13/2003 09:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
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:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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 Mon Oct 13 2003 - 13:19:36 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |