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…