How to use DML on Oracle temporary table without generating much undo log
Posted
by Sambath
on Stack Overflow
See other posts from Stack Overflow
or by Sambath
Published on 2010-03-12T04:20:29Z
Indexed on
2010/03/12
4:27 UTC
Read the original article
Hit count: 249
Hi,
Using an Oracle temporary table does not generate much redo log as a normal table. However, the undo log is still generated. Thus, how can I write insert, update, or delete statement on a temporary table but Oracle will not generate undo log or generate as little as possible?
Moreover, using /+append/ in the insert statement will generate little undo log. Am I correct? If not, could anyone explain me about using the hint /+append/?
INSERT /*+APPEND*/ INTO table1(...) VALUES(...);
Thank you.
© Stack Overflow or respective owner
