Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to handle temporary tablespace (locally managed) during restoration from a hot backup?

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

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 14 Jul 2003 06:54:16 GMT
Message-ID: <sssQa.617$pk1.243@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 Mon Jul 14 2003 - 01:54:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US