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

From: Saikat Chakraborty <saikatchak_at_hotmail.com>
Date: Thu, 25 Sep 2003 09:42:05 +0000 (UTC)
Message-ID: <2b5c06fea6551bb7cc15e3f7495a8853.16981@mygate.mailgate.org>

If the tablespace is made up of "TEMPFILE" instead of datafiles then no. you can not.
However for tablespaces created with datafiles, you can do "alter tablespace parmanent".
Thanks,
Saikat
"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?
>
> Thanks

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Thu Sep 25 2003 - 04:42:05 CDT