Re: Temp01.dbf deleted. Is recovery possible?

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<brq7bj$43u$1_at_news.fujitsu-siemens.com>...
> "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

Have it do something a that writes to the tempfile, such as a sort. It is a feature in Oracle that it doesn't care about whether the tempfile is there until it needs it. See http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=ac826aa3095d254d&rnum=1 (or subject "Trivia Question - File Date" if that doesn't work).

Probably the easiest thing to do would be select the filenames out of the db and ls them, check for "not found."

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/wed/currents/news_mz1c17otay.html