Ryan - The only time I did was when I needed to expand the SYSTEM tablespace
because it was too small. Normally you can just expand the datafile. For
some reason I couldn't do that, it was awhile ago, probably the Oracle
version. Creating another data file went just fine.
The more important issue is keeping stuff out of the SYSTEM tablespace
so it doesn't grow. Watch very carefully any objects residing in the SYSTEM
tablespace that aren't owned by SYS. Make sure nobody is using SYSTEM as
their temp or default tablespace, etc. The problem is that shrinking the
SYSTEM tablespace is very hard to do.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, July 24, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Would you ever want to use multiple data files for the system tablespace?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
