Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.freenet.de!news.tiscali.de!news.belwue.de!not-for-mail
From: Holger Baer <holger.baer@science-computing.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: TEMP tablespace: a big one or 10 small ones?
Date: Wed, 14 Sep 2005 16:28:31 +0200
Organization: InterNetNews at News.BelWue.DE (Stuttgart, Germany)
Lines: 14
Message-ID: <dg9c2g$mcv$1@news.BelWue.DE>
References: <1126686836.529573.152920@z14g2000cwz.googlegroups.com> <1126687353.062965.132610@g43g2000cwa.googlegroups.com>
NNTP-Posting-Host: blackhole.science-computing.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.BelWue.DE 1126708112 22943 193.197.16.3 (14 Sep 2005 14:28:32 GMT)
X-Complaints-To: news@news.belwue.de
NNTP-Posting-Date: Wed, 14 Sep 2005 14:28:32 +0000 (UTC)
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050512
X-Accept-Language: en-us, en
In-Reply-To: <1126687353.062965.132610@g43g2000cwa.googlegroups.com>
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251489

sybrandb@yahoo.com wrote:
> The temporary tablespace to be used is recorded against the user. This
> means every session will only use one temp tablespace ever: the one
> recorded in dba_users.
> 

This question is about 10g.

Perhaps you read at least this before answering such questions:

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/tspaces.htm#sthref1141

Regards,
Holger