Re: How to handle temporary tablespace (locally managed) during restoration from a hot backup?

Or alter tablespace temp add tempfile '/file/location' size xxM reuse;

Tanel.

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:sssQa.617$pk1.243_at_news02.roc.ny...
>
> "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 Tue Jul 15 2003 - 05:59:30 CDT