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 -> Default value of pct_increase

Default value of pct_increase

From: Marc Billiet <Marc.Billiet_at_alcatel.be>
Date: 1997/08/05
Message-ID: <33E6D420.2DB1@alcatel.be>#1/1

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

Original text of this message

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