Which ablespace for users SYS and SYSTEM

From: <oamador_at_obipr.jnj.com>
Date: Wed, 03 Mar 1999 23:20:00 GMT
Message-ID: <7bkg2k$i0$1@nnrp1.dejanews.com>

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 Received on Wed Mar 03 1999 - 17:20:00 CST