Justin,
Do not change the way Oracle sets up the system tablespace. Let it do it's thing. I have never had a problem with it other than to resize next extents for certain objects from time to time, but that's rare.
HTH
Lisa Koivu
Extreeeeeemely Bored Janitor (aka dba)
Ft. Lauderdale, FL, US
-----Original Message-----
From: Justin Coleman [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: Extent size for system tablespace
Experts,
From an earlier e-mail, I found out that LMT was not possible with the
SYSTEM tablespace. Thanks for that info. So if using Data Dictionary
managed tablespaces for the SYSTEM tablespace, when setting up a new
database, should you change the default extent size for the system space and
change pctincrease from 50% down to 0%?
Cheers for any help in advance.
Justin
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Justin Coleman
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
