Path: =
col.hp.com!sdd.hp.com!enews.sgi.com!newsfeed.berkeley.edu!news.algonet.s=
e!algonet!uninett.no!uio.no!newsfeed1.funet.fi!newsfeed.uninet.ee!news.u=
t.ee!not-for-mail
From: "Hasso Brück" <hasso@*remove*to*mail*korel.ee>
Newsgroups: comp.databases.oracle.server
Subject: Re: PCTINCREASE for SYSTEM
Date: Mon, 27 Dec 1999 16:27:29 +0200
Lines: 24
Message-ID: <847sot$e8g$1@kadri.ut.ee>
References: <38672745.3CFA1683@nospam.exchange.japan.ml.com> =
<38676E17.EFB196AA@Unforgettable.com>
NNTP-Posting-Host: sys141.korel.ee
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
X-Trace: kadri.ut.ee 946304605 14608 194.126.100.141 (27 Dec 1999 =
14:23:25 GMT)
X-Complaints-To: usenet@news.ut.ee
NNTP-Posting-Date: 27 Dec 1999 14:23:25 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Xref: col.hp.com comp.databases.oracle.server:99705


Kenneth C Stahl wrote in message =
<38676E17.EFB196AA@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.