Help, how do I simulate a temproary table ?

[pando]

Third is the UNDO log, which ensures that an uncommitted change can be rolled back and is also used for read-consistency. NOLOGGING options can minimize the amount of UNDO, but these are generally only useful for bulk operations, not transaction processing.

nologging is used to reduce both redo and undo