Xref: alice comp.databases.oracle.server:73633
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!newsfeed.enteract.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: Nandakumar <N.Kumar@rocketmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: temporary
Date: Thu, 11 Nov 1999 22:43:50 GMT
Organization: Deja.com - Before you buy.
Lines: 41
Message-ID: <80fgr4$hv3$1@nnrp1.deja.com>
References: <80f679$9gv$1@nnrp1.deja.com> <80f996$bv2$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Nov 11 22:43:50 1999 GMT
X-Http-User-Agent: Mozilla/4.51 [en] (WinNT; I)
X-Http-Proxy: 1.0 x23.deja.com:80 (Squid/1.1.22) for client 209.117.251.206
X-MyDeja-Info: XMYDJUIDnanban

if that is the fact, aren't there any advantages in using the temporary
segments from a TEMPORARY TABLESPACE rather than PERMANENT TABLESPACE? i
guess there should be some.

thanks &
regards
Nanda


In article <80f996$bv2$1@nnrp1.deja.com>,
  Ben Ryan <benryan@my-deja.com> wrote:
> In article <80f679$9gv$1@nnrp1.deja.com>,
>   Nandakumar <N.Kumar@rocketmail.com> wrote:
> > Isn't it necessary to have one TEMPORARY tablespace in a database?
> > I don't find any tablespace with CONTENTS - TEMPORARY in my 'working
> > fine' database.
>
> Good practise, yes. Essential no.
>
> By default Oracle uses the system tablespace for temporary segments.
>
> Oracle defines which tablespace will be used for temporary segments
> on a per user basis, rather than as a database wide attribute. So to
> detemine which tablespace(s) is (are) being used is matter of looking
> at the temporary_tablespace column of the dba_users table.
>
> The temporary attribute of a tablespace means that the tablespace
> is reserved for temporary segments. However, this does not
> necessarily mean anyone is using the tablespace.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Nandakumar
(N.Kumar@rocketmail.com)


Sent via Deja.com http://www.deja.com/
Before you buy.