Re: Temp01.dbf deleted. Is recovery possible?

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Thu, 18 Dec 2003 00:33:57 +0100
Message-ID: <nop1uvcn4ihqukj03ajso1et78esh9t4qo@4ax.com>

On Wed, 17 Dec 2003 19:30:10 +0100, "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote:

>
>"Brian Peasland" <dba_at_remove_spam.peasland.com> schrieb im Newsbeitrag news:3FE09D0E.B40D9294_at_remove_spam.peasland.com...
>> > Is this really a tempfile?
>>
>> Probably not. It's probably a *datafile* assigned to the temporary
>> tablespace, i.e. the "old-school" way of doing it. If it were a
>> tempfile, then it would behave as you have suggested.
>Okay and how can I make the database detect and signal
>a missing tempfile?
>
>Lots of Greetings!
>Volker

The answer those this was already posted prior to your response. Check your newsfeed and/or google

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Dec 17 2003 - 17:33:57 CST