Re: Temporary Tablespaces

krishnanand_at_hotmail.com wrote:

>Hi,
>
>
> A few questions on TEMP tablespaces: ( Oracle 7.3.2.1 )
>
> (1) The DBA_TABLESPACES has a column called CONTENTS - in our default
>
> settings it shows PERMANENT for all the tablespaces. It has 2 optins
>
> PERMANENT & TEMPORARY. Can I change this TYPE from PERMANENT to
>
> TEMPORARY when the Database is UP & RUNNNING. Do I need to take any
>
> SPECIAL steps/precautions. Please HELP.

Yup - no special considerations needed.
>
>
> (3) Can I add another TEMP tablespace - sounds STUPID but is it
>possible?
>
> In other words can I make Oracle to do sorting in some tablespace
>
> other than (TEMP - created at installation ) ?

Yup - makes sense if you want different users to use different TEMP tablespaces.

>
>
> Please reply by EMail also.
>
> Thanx.
>
>
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Thu Nov 27 1997 - 00:00:00 CST