title: Want to enable PARALLEL and NOLOGGING on Oracle Delete statement
body: <p>I have a very huge table with more than 3.5 billion records that increases 500K each day, I want to delete all records before year 2014. Every delete command I run, after few hours fall into error state, so I am looking at doing this job faster, last command I run was: </p>
  
  <pre><code>DELETE /*+ PARALLEL (8) */ FROM XYZ WHERE YEAR &lt;= 2014;
  </code></pre>
  
  <p>After 744 minutes I get </p>
  
  <blockquote>
    <p>ORA-12801: error signaled in parallel query server</p>
  </blockquote>
  
  <p>I guess if I could run the DELETE command with both PARALLEL and NOLOGGING, switch maybe I could do this, but I don't know how to run the session in NOLOGGING state and at the same time enable PARALLEL for the command, also I know we can run</p>
  
  <pre><code>DELETE /*+ NOLOGGING PARALLEL (8) */ FROM XYZ WHERE YEAR &lt;= 2014;
  </code></pre>
  
  <p>But as I find in somewhere, it seems that with this command PARALLEL hint will be ignored.</p>
  
  <p>Please advise on how to run the  DELETE command both in PARALLEL and NOLOGGING </p>