Re: default storage for SYSTEM tablespace

From: <markp7832_at_my-deja.com>
Date: Wed, 26 Jan 2000 22:09:25 GMT
Message-ID: <86nrah$sb$1@nnrp1.deja.com>

In article <86ni9v$phg$1_at_nnrp1.deja.com>, edstevens_at_my-deja.com wrote:
> When we create a new database, the SYSTEM tablespace is created with
a
> pctincrease of 50%. All recommendations say that tablespaces and
> tables should be have a pctincrease of 0. This is no problem for
> objects we create, but how do we control this for SYSTEM tablespace at
> DB creation time?
>

The recommendations you reference do not apply to the system tablespace; you should leave it as Oracle sets it. However, make sure only sys owned or other install provided ID's have objects in the system tablespace. And if you install any Oracle tools make sure that these tables are placed in a non-system tablespace unless the install instruction specify otherwise.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 26 2000 - 16:09:25 CST