Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Which ablespace for users SYS and SYSTEM

Re: Which ablespace for users SYS and SYSTEM

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Thu, 4 Mar 1999 14:11:50 -0000
Message-ID: <920556893.9241.0.nnrp-11.c2de6f3d@news.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US