Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to convert tablepace from temporary to permanent?
On Thu, 25 Sep 2003 09:42:05 +0000 (UTC), "Saikat Chakraborty" <saikatchak_at_hotmail.com> wrote:
In other words, if you are using local extent management then you cannot convert the tablespace to permanent.
Thanks
>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
Received on Thu Sep 25 2003 - 18:27:22 CDT