Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Tue Mar 27 2007 - 01:13:01 CDT
![]() |
![]() |