Re: PCTINCREASE for SYSTEM

From: MLJ <dinyar_ghyara_at_nospam.exchange.japan.ml.com>
Date: Tue, 28 Dec 1999 14:31:02 +0900
Message-ID: <38684B16.94F2FE7A@nospam.exchange.japan.ml.com>

Thanks a lot guys.
You've been a big help.
Dinyar

"Hasso Brück" wrote:

> 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 - 23:31:02 CST