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 -> Re: Why is undo backed with redo for GTT

Re: Why is undo backed with redo for GTT

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sun, 2 Mar 2003 18:05:06 +0200
Message-ID: <3e622b0c_2@news.estpak.ee>


Hi!

> Another solution would be to have different type, non-logging rollback
> segments for GTT DML, but this would make overall architecture more
complex.
> But, IMHO, we should keep everything as simple as possible (this applies
to
> everything, not only Oracle or IS issues).

One option would be disabling rollback to a savepoint for GTT DML or adding an option to control whether to generate undo or not.

I wonder whether flasback query is available with GTTs?

Tanel. Received on Sun Mar 02 2003 - 10:05:06 CST

Original text of this message

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