RE: Standbys and Temp Space

From: Kevin Lange <klange_at_ppoone.com>
Date: Tue, 27 Mar 2007 17:33:55 -0500
Message-ID: <7CFD053DDD9A7C4D81615E33EED7ACD9012CDAE6@pp1msrv1.pp1.com>

I was sure of the answer before I wrote. But, before I go and change the code and then have something happen I always like to get a second or third opinion. Something about screwing with my backups that I like to be validated on.

-----Original Message-----
From: Mladen Gogala [mailto:mgogala_at_verizon.net] Sent: Tuesday, March 27, 2007 1:13 AM
To: hkchital_at_singnet.com.sg
Cc: Kevin Lange; oracle-l_at_freelists.org
Subject: Re: Standbys and Temp Space

On 03/26/2007 11:19:48 PM, Hemant K Chitale wrote:
>
> No, you do not need the TEMPFILEs.

Of course you don't. Temporary tablespace blocks are not protected by redo. Sometimes, they are protected by undo. If that wasn't the case, global temporary tables would break the transaction rules. Of course, undo blocks are protected by redo. Things are simple, aren't they?

--
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 27 2007 - 17:33:55 CDT