How to use DML on Oracle temporary table without generating much undo log
- by Sambath
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.
