Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SYSTEM user not in SYSTEM tablespace

Re: SYSTEM user not in SYSTEM tablespace

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Thu, 19 Nov 1998 14:07:15 +0100
Message-ID: <7315be$le$1@sunrise.pg.gda.pl>


Anne-Marie Ternes wrote in message <36540CBD.FFDE550C_at_cie.etat.lu>...
>Hi all,

[cut]
>Indeed, the SYSTEM user has as "default tablespace" the setting TOOLS,
>i.e. the TOOLS tablespace.
>
>I have no idea how this came to be, but I wondered, can I change the
>tablespace back to SYSTEM tablespace?
>Are there any risks? Could it disturb the functioning of the database?
>
>I know very well that playing with the SYSTEM tablespace can be
>perilous, that's why I would like to have your advice.
>
>Thank you very much for any suggestions or warnings ;-)

Hi,
Tablespace SYSTEM is intended to keep objects belonging to SYS (in fact, Oracle RDBMS kernel).
SYSTEM is primarily intended to keep repositories of any oracle tools. So if database is created via orainst on unix its default tablespace is TOOLS (but not for example on NT ;-)). However, this naming convention of schemas and its defaul tablespaces may appear as not very clear...
Warnings... It is not desirable to store any objects (except of owned by SYS) in SYSTEM tablespace for several reasons. Primarily for performance reason (contention on datafiles) and availability (for example you can't take SYSTEM offline).

Piotr Kolodziej
pkol_at_otago.gda.pl Received on Thu Nov 19 1998 - 07:07:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US