Re: Any way to disable UNDO (rollback) with temporary tables?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 4 Dec 2003 15:19:26 +1100
Message-ID: <3fceb5cf$0$20488$afc38c87@news.optusnet.com.au>

"Michael J. Moore" <NOhicamelSPAM_at_comcast.net> wrote in message news:nvxzb.298837$ao4.1028292_at_attbi_s51...
> Well, I have not read the book and I am just a novice, but I understand
> NetComrade when he says he does not need the data in UNDO. From a high
level
> logical perspective there would seem to be no need to roll back a temp
table
> when it can just be chucked. So, what else is being stored in the UNDO
> related to temp table transactions. Maybe there are some bit maps that
need
> to be rolled back? I believe that UNDO is required for inserts into temp,
> but I'd like to understand why?
> Mike
>

I haven't tried this... but can you flashback on a temporary table?

If so, the use for undo becomes obvious.

Regards
HJR Received on Wed Dec 03 2003 - 22:19:26 CST