Re: Error when renaming tempfile

From: Fraser McCallum <fmcc_at_removetoemail_odbaguru.com>
Date: Wed, 13 Mar 2002 10:39:36 +1100
Message-ID: <Jgwj8.10101$uR5.18716@newsfeeds.bigpond.com>

Repost below.

I'm assuming you have used the 8i temporary files, i.e. this file shows up when you query DBA_TEMP_FILES. You can't rename locally managed temporary files, just as you can't recover them. However this is not a problem as being a temporary file means that no data is stored in them. So for your move just drop and recreate the tablespace.

Kind Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"bdick" <bdick_at_cox.net> wrote in message news:QAoj8.9058$E_3.991468_at_news2.east.cox.net...
> "Fraser McCallum" <fmcc_at_removetoemail_odbaguru.com> wrote in message
> news:wrbj8.9428$uR5.15039_at_newsfeeds.bigpond.com...
> > The one in which I replied to your original query, prior to your posting
> of
> > your tablespace creation syntax.
>
> Don't see it. Can you repost?
>
> --
> BEDick
>
>
>
Received on Tue Mar 12 2002 - 17:39:36 CST