Re: Insert without redo log

I just did a test. create global temporary table testgtt (a number) on commit preserve rows in one session. Run:

begin
for i in 1..100000 loop
insert into testgtt values (i);
end loop;
end;
/

Monitor v$rollstat in another session. Indeed the rollback is being used. This is a one person database.

Yong Huang
yhuang_at_indigopool.com

Howard J. Rogers <howardjr_at_www.com> wrote in message news:3a8bcf89_at_news.iprimus.com.au...
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:982225998.12720.0.nnrp-08.9e984b29_at_news.demon.co.uk...
> >
> > Inserts into temporary table generate rollback,
> > and the rollback is covered by redo, so an insert
> > into a temporary table does results in redo -
> > albeit less than that required for a normal table.
>
> Mmmm... hadn't thought about that. The manuals state (in their inimitable
> bullet point fashion!) "No redo generated for DML" for temporary
 tables....
> I could have sworn they also said no rollback, but I must just be
 imagining
> it. I think I should have just stuck with the short answer: "No". Has a
> certain conciseness about it!!
Received on Thu Feb 15 2001 - 13:40:51 CST