Re: Change PCTINCREAE for SYSTEM Tablespace

Ken,

The system tablespace is created in the file sql.bsq, which should be found in %ORACLE_HOME%\rdbms\admin. Create tablespace system is the first statement in the file.

However, before you touch that file, you MUST read Steve's article at http://www.ixora.com.au/tips/creation/bsq.htm.

Two points he makes: 1 - Don't edit sql.bsq, make a copy and edit and use the copy, 2- leave the defaults alone, and set a minimum extent of 64k on the system ts.

Really, read the page before you do it.

HTH, Yosi

Ken Janusz wrote:

> Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace
> without recreating the DB? For some reason the person who created the DB I
> am working on set PCTINCREASE to 50 (or didn't did not include this
> parameter). I am using this DB for a data conversion so there is no
> software connected to it and in turn no users on it.
>
> Thanks,
> Ken Janusz, CPIM
> Database Conversion Lead
> Sufficient Systems, Inc.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
> INET: ken.janusz_at_sufsys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: yosi_at_comhill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).