Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to handle temporary tablespace (locally managed) during restoration from a hot backup?
"Jeffrey Yee" <jeffyee_at_hotmail.com> wrote in message news:ec4cec95.0307132158.19349895_at_posting.google.com...
> Hi,
>
> I realise that temporary tablespace tempfile (locally managed) cannot
> use the alter tablespace begin backup command. Therefore, I wonder
> what would be the best way to recover the tempfile.
>
--snip--
> Best Regards,
> Jeffrey Yee
No need to recover them. Drop recreate.
Anurag Received on Mon Jul 14 2003 - 01:54:16 CDT