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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 25 Sep 2003 11:57:08 +0100
Message-ID: <3f72ca05$0$252$ed9e5944@reading.news.pipex.net>

"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

Received on Thu Sep 25 2003 - 05:57:08 CDT