title: Out of Memory Error : when executing Very Large Scripts in toad
body: <p>I am using</p>
  <ul>
  <li>Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod <code>&amp;</code></li>
  <li>Toad for oracle 10.6.1.3</li>
  </ul>
  <p>when i try to run insert statement which is having around <code>84,000 +</code> records, it is showing <code>Out of Memory</code> error. Here is the error image.</p>
  <p><img src="https://i.stack.imgur.com/MUGri.jpg" alt="Out of Memory Error" /></p>
  <p>Any of you please suggest me, how i should execute this insert script in toad.</p>
  <p><strong>P.S :</strong> since toad is connecting to remote machine I'm not able to run it with SQLPLUS. If any one knows option to do that, please let me know.</p>
  <p>If you need any more information, Please raise your hands in comment box i will provide you.</p>