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

On Thu, 25 Sep 2003 11:57:08 +0100, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> 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?

After the conversion to permanent, I am not going t o use it for storing permanent objects anymore.
Thanks Received on Thu Sep 25 2003 - 18:34:13 CDT