title: Temporarily Disabling Constraints in Oracle Database
body: <p>I have an Oracle SQL delete statement that is taking a very long time to run. It's very simple, something like:</p>
  
  <pre><code>delete from table
  where fy = 2016
  </code></pre>
  
  <p>I also manually tried deleting one of the ~2500 rows I need to get rid of in TOAD and it's taking about 6 minutes to delete a single row.</p>
  
  <p>I think the reason for this is that the table has a lot of constraints on it, so I'm wondering if I can somehow change my delete statement in such a way that it can bypass the constraints or disable them temporarily in order to do it much faster? If so, how can I re-enable them afterwards?</p>