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: Tanel Poder <tanel_at_@peldik.com>
Date: Tue, 15 Jul 2003 13:59:30 +0300
Message-ID: <3f13de97_1@news.estpak.ee>


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

Original text of this message

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