title: Oracle How to Avoid writes to UNDO / REDO log
body: <p>I have an Oracle PL / SQL script. It processes about 51 millon registers, and writes results to 5 different tables.</p>
  
  <p>The problem is that I left the process running last night, and apparently there was an overflow in the UNDO logs.</p>
  
  <p>Particularly, we are not interested in Rollbacking this script, if it fails, we can run it again.</p>
  
  <p>Is there any way optimize the usage of the undo / redo logs? Avoid writing them or minimizing those writes? </p>
  
  <p>As far as I understand, setting the NOLOGGING attribute the output tables would help, in addition to using the APPEND insert (as said <a href="https://stackoverflow.com/questions/199537/oracle-sql-technique-to-avoid-filling-trans-log">here</a>).</p>