Re: Which ablespace for users SYS and SYSTEM

In article <7bkg2k$i0$1_at_nnrp1.dejanews.com>,   oamador_at_obipr.jnj.com wrote:
> Why is user SYS setup in oracle to have assigned default tablespaces SYSTEM
> and temporary table space TEMPORARY and the use SYSTEM is setup to have
> default USR and temporary SYSTEM?
>
> I also notice that another application was creating user with a temporary
> tablespace SYSTEM.
>
> Shouldn't it all users be assigned TEMPORARY as their temporary table space.
> After all, isn't the reason the tablespace is defined as of type temporary?
>
> And this USR tablespace, is it really necessary? The only one assigned to it
> is SYSTEM and there is no objects in the table. Shouldn't system be using the
> SYSTEM tablespace as default?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

There were some pretty good posts on this topic a couple of months back. You can search the archives.

The consensus was that SYSTEM is just a DBA id that Oracle comes with that Oracle products like Forms and ReportWriter expect to be their owner. It is safe to change the default and temporary tablespace parameters for it.

SYS on the other hand should be left alone. It is the database owner and is used to start, stop, recover, and upgrade the database and should not be used for anthing else, except running queries or doing grants on sys owned objects like the dbms packages and v$tables as a part of normal operations and procedures.

Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 04 1999 - 08:42:12 CST