Re: Myths & legends: temporay segments and redo

On 02/11/2006 04:38:51 PM, Jonathan Lewis wrote:
>
> As a cross-check, you need to compare the redo
> from using a GTT with the redo from using a
> normal table.
>
> The answer to your puzzle is that changes to the
> GTT do not generate redo, but they do generate
> undo, and the undo generates redo.

How about the "normal" temporary segments, the ones allocated by sorts?

-- 
Mladen Gogala
http://www.mgogala.com

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