Re: temporary

Hi

You should create ( or alter ) temporary tablespace and set it all user.

Oracle will use it to sort operation with a special mode than the other tablespaces.
If you do not have a temporary tablespace all of sort operation doing in a normal tablespace. So i think you cannot yield a good performance.

feherl

Nandakumar wrote:

> hi,
>
> 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.
>
> thanks in advance for all responses.
>
> --
> Nandakumar
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 11 1999 - 15:15:35 CST