Re: SYSTEM user not in SYSTEM tablespace

There is nothing wrong with having the default tablespace for user 'system' being tools. This, in fact, is probably a good choice.

System is just a DBA user that happens to come predefined to Oracle. The id has no special powers or use. Pretty much all the Oracle development applications that need tables in the database like Oracle Forms and Oracle ReportWriter came with product installation scripts that expected the owner to be system and create their tables using the owner's default tablespace. Oracle itself provides examples of using a tablespace named Tools to hold these type of products.

Changing the default or temporary tablespace for user 'system' is not the same as playing with the 'system' tablespace. Indeed the idea of changing user system's default tablespace to a tablespace other than system is an attempt to keep the system tablespace free of non-Oracle internal tables that really make up the Oracle dictionary like sys.seq$.

Anne-Marie Ternes <anne-marie.ternes_at_cie.etat.lu> wrote in article <36540CBD.FFDE550C_at_cie.etat.lu>...
> Hi all,
>
> I have discovered a somewhat strange fact in our database (Oracle 7.3.3
> on SUN Solaris).
> 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 ;-)
>
> Anne-Marie Ternes
> CIE, Luxembourg
>
>
  Received on Thu Nov 19 1998 - 00:00:00 CET