Re: Standbys and Temp Space

  • From: Mladen Gogala <mgogala@xxxxxxxxxxx>
  • To: hkchital@xxxxxxxxxxxxxx
  • Date: Tue, 27 Mar 2007 02:13:01 -0400

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

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


Other related posts: