Re: Default value of pct_increase

The most likely reason that your tables are being created with a PCT_INCREASE of 0 is that the default storage parameter of the tablespace is set to 0. To find out, try:

SELECT * FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = 'tablespace_name';

When an object such as a table is created in this tablespace, it will take the default storage parameters if not supplied in the CREATE TABLE command.

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 100+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Marc Billiet (Marc.Billiet_at_alcatel.be) wrote:
: It may be a very basic question, but according to the Oracle manual
: (Oracle 7 Server SQL Language Reference Manual), the default value of
: pct_increase is 50. When I create a table, pct_increase is always set to
: 0. Is it possible that the default has changed somehow (can the dba have
: done this ?).
: To check this, I did the following in SQL*Plus :
: SQL> create table marc (x number);
:
: Table created.
:
: SQL> select pct_increase from user_tables where table_name = 'MARC';
:
: PCT_INCREASE
: ------------
: 0
:
: Is there any reason why it is always set to 0 (not only in this example)
: ?
: The Oracle version is 7.3.2.3.0 on HP-UX.
:
: Thank you for your time,
:
: Marc Billiet
Received on Tue Aug 05 1997 - 00:00:00 CDT