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

Home -> Community -> Usenet -> c.d.o.server -> Why is undo backed with redo for GTT

Why is undo backed with redo for GTT

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 2 Mar 2003 13:06:22 GMT
Message-ID: <b3svke$1oju4r$1@ID-82536.news.dfncis.de>


Hello

One of the benefits of global temporary tables (gtt) is that it does not generate as much redo as 'normal' tables (See also a paralell thread on c.d.o.s). However, ggt's do generate undo which is backed by redo. Now, I do understand why the undo is necessary, but I don't understand why this undo must be backed by redo. In case of a crash, only the structure of the gtt must be recovered, not its content. So, it seems to me, that there is nothing to be rolled back on the ggt, hence the undo generated for the ggt needs not be recovered.

What am I missing?

Thanks
Rene Nyffenegger

-- 
  no sig today
Received on Sun Mar 02 2003 - 07:06:22 CST

Original text of this message

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