title: ORA-30009: Not enough memory for CONNECT BY operation
body: <p>I have a <strong>Linux VM (with CentOS 64 bit)</strong> where I installed <strong>Oracle Database 11g Express Edition</strong>. The database is running, I can use sqlplus and I can create tables and stuff. However, when I run a certain SQL script which inserts a huge amount of random data (~2 million rows) I get this error:</p>
  
  <pre><code>ORA-30009: Not enough memory for CONNECT BY operation
  </code></pre>
  
  <p>I already tried to increase <code>PGA_AGGREGATE_TARGET</code> with the command below. As far as I read this should solve the problem (but it doesn't) since it increases the memory.</p>
  
  <pre><code>ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 40M scope = both;
  </code></pre>
  
  <p>However, the problem is that I can not set <code>PGA_AGGREGATE_TARGET</code> higher than ~40M (which seems to be not sufficient). If I try to set it up to 100M or more I get another error:</p>
  
  <pre><code>ERROR at line 1:
  ORA-02097: parameter cannot be modified because specified value is invalid
  ORA-47500: XE edition memory parameter invalid or not specified
  </code></pre>
  
  <p><strong>Any idea how I can solve this problem?</strong> It is perfectly fine for me to re-install the whole database or whatever.</p>
  
  <p><em>PS.: I asked the same question on dba.stackexchange.com since I wasn't sure whether it is programming or database administration.</em></p>