Re: Relocating SYSTEM’s objects.

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 04 Feb 2000 08:34:52 -0800
Message-ID: <389AFFAC.9C0E676E@us.oracle.com>

As a matter of fact, SYSTEM can own objects. Some of the replication / AQ tables end up being owned by SYSTEM, though I've never seen an explanation of why. Also, SYSTEM is the owner of the PRODUCT_USER_PROFILE table, that all every DBA creates if only to get rid of the annoying table not found message on login to SQL*Plus.

HTH. Pete

Doktor wrote:

> Ed Stevens wrote:
> >
> > This is a follow on to previous msgs regarding default tablespaces for
> > user SYSTEM, wherein we had allowed SYSTEM to have the system
> > tablespace as his default. Now I’m am practicing for a migration
> > effort to move all of his objects from the system tablespace to the
> > recommended TOOLS. This is a bit lengthy, but please bear with me.
>
> Recommended ? Objects for user SYS (SYSTEM has none objects !, only
> privileges) must exist in tablespace SYSTEM

Received on Fri Feb 04 2000 - 10:34:52 CST