Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Standbys and Temp Space

Re: Standbys and Temp Space

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Tue, 27 Mar 2007 02:13:01 -0400
Message-id: <1174975981l.3279l.0l@medo.noip.com>


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 - 01:13:01 CDT

Original text of this message

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