Re: Is it possible to convert tablepace from temporary to permanent?

I have to echo Niall's comments. Why?!?!?!?! What is in this temporary tablespace that you wish to make "permanent"? Anything in this tablespace, by definition, is temporary. So if you want a permanent tablespace, just make one!

Cheers,
Brian

Niall Litchfield wrote:
>
> "Peter" <peter_at_nomorenewspamin.ca> wrote in message
> news:58b4nvca40amhj73472ppu08ik54d82de5_at_4ax.com...
> > Is it possible to convert a tablepace from temporary to permanent?
> > Is it better to drop a temp tablespace and create a permanent
> > tablespace from scratch?
>
> Others have given you the answer, I'm just going to question your sanity
> :( Why are you converting a temp tablespace to a permanent one? If you want
> a new tablespace create one. If you want to drop a temp tablespace (because
> you have more than one maybe) then drop it - but why store temporary objects
> in a permanent tablespace if you can store them in a temporary one?
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
 

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"