Re: PCTINCREASE for SYSTEM

From: Hasso Brück <hasso_at_*remove*to*mail*korel.ee>
Date: Mon, 27 Dec 1999 16:27:29 +0200
Message-ID: <847sot$e8g$1@kadri.ut.ee>

Kenneth C Stahl wrote in message <38676E17.EFB196AA_at_Unforgettable.com>...
>> Is there a way to change the PCTINCREASE for SYSTEM from 50 to 0?
>Same was as you would with any other tablespace.
>alter tablespace system default storage (pctincrease 0);
Yeah, but he's probably about changing this pctincrease _before_ some system objects are created with "create database ...".

Look into $ORACLE_HOME/dbs/sql.bsq (Oracle 7.x) or $ORACLE_HOME/rdbms/admin/sql.bsq (Ora 8.x)

By changing this file you can change default storage parameters for oracle system objects.

Yeah, it's good idea to consult with support staff before you change something critical ... ;-)

---
Hasso Brück
Technical Manager
Korel SYS Ltd. Received on Mon Dec 27 1999 - 08:27:29 CST