Re: temporary

From: Ben Ryan <benryan_at_my-deja.com>
Date: Thu, 11 Nov 1999 20:34:46 GMT
Message-ID: <80f996$bv2$1@nnrp1.deja.com>

In article <80f679$9gv$1_at_nnrp1.deja.com>, Nandakumar <N.Kumar_at_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. Received on Thu Nov 11 1999 - 14:34:46 CST