Re: temporary tablespace usage

From: Yong Huang <yong321_at_yahoo.com>
Date: 1 Dec 2002 07:51:05 -0800
Message-ID: <b3cb12d6.0212010751.44cff6d5@posting.google.com>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<K8hG9.87428$g9.246164_at_newsfeeds.bigpond.com>... ...
> But if you had an enormous temporary tablespace, that would mean sitting
> there for (potentially) hours waiting for the damn thing to be recreated. So
> you might well have chosen instead the alternative strategy: restore the
> datafile and recover it. And the minute you propose to recover your
> temporary tablespace, you have to have redo available for it. Hence logging
> made a certain kind of sense.

But Oracle never generates any redos for temporary segments, even before we have tempfiles. Why does it need redo logs for recovery?

Yong Huang Received on Sun Dec 01 2002 - 09:51:05 CST