Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: questions about "system" and temporary tablespaces
On Fri, 05 Feb 1999 21:14:42 GMT, kal121_at_yahoo.com wrote:
>I just installed Oracle 8 (custom). When I query the dba_users view, I see
>that system and sys have as their temporary tablespace the system tablespace.
>Somehow I don't think that is a good idea. I went ahead and changed their
>temp tablespace to a temp table I called "Temporary_Data".
>
>My question is, why did the installation give sys and system the system
>tablespace for their temporary tablespace? Is it because I changed the name of
>the original default temp table during the installation, and hence, could not
>find it?
>
>Also, who is the DBSNMP user?
There is no way Oracle could possibly know how many tablespaces the database will be created with or what their names would be. The only things that is 100% sure is: if there will be a database, it will surrely contain tablespace named "SYSTEM", as the "CREATE DATABASE..." command itself will create it (provided noone messes with the sql.bsq).
SYSTEM my well be the only tablespace in the database (although this would be realy an extremely imbecile db design), so the only logical choose is to assign this tablespace to all automatically created users. It is then the responsibility of a DBA to change defaults for temporary tablespace for users SYS and SYSTEM (also the default tablespace for SYSTEM).
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)