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: Temp01.dbf deleted. Is recovery possible?

Re: Temp01.dbf deleted. Is recovery possible?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 17 Dec 2003 19:30:10 +0100
Message-ID: <brq7bj$43u$1@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 Received on Wed Dec 17 2003 - 12:30:10 CST

Original text of this message

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