Sys has a temp tablespace of system because an instance must have the system
tablespace
online and therefore it means that sys's default and temp tablespace are
always online ..
makes sense to me :)
oamador_at_obipr.jnj.com wrote in message <7bkg2k$i0$1_at_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 Thu Mar 04 1999 - 08:11:50 CST
