Re: Changing TEMP tablespace from type PERMANENT to type TEMPORARY

From: Gollum <gollum_nospam_at_worldonline.dk>
Date: Tue, 6 Feb 2001 21:40:52 +0100
Message-ID: <gmZf6.32121$l57.1407636@news000.worldonline.dk>

No need to bring the database down - just ALTER TABLESPACE TEMP TEMPORARY;

HTH,
Gollum

<dmnwork_at_my-deja.com> wrote in message news:95pmqo$p6e$1_at_nnrp1.deja.com...
>
>
> On an Oracle 8.0.5. database, someone made the TEMP tablespace to be
> type PERMANENT. I'd like to change it to type TEMPORARY. Would I need
> to take the database down and put it into mount mode to issue an alter
> tablespace command on it?
>
> I queried dba_segments for the tablespace in question, and sure enough
> all the segments in it are owned by SYS and are of type TEMPORARY; so
> no one's storing anything else but temporary segments in it.
>
> Thanks very much.
>
> - Dana
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Feb 06 2001 - 14:40:52 CST