title: Should I disable or drop indexes when doing a high volume insert on Oracle?
body: <p>I'm doing a high-volume insert-into-select-from statement in Oracle, and I'm running out of undo space (ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1').</p>
  
  <p>The general consensus seems to be to drop indexes on the target table and then recreate them when the insert completes.</p>
  
  <p>Is just disabling the indexes/constraints on the table ok? How is it different from dropping the indexes/constraints?</p>