ORA-30009: Not enough memory for CONNECT BY operation
Here are a few tips that might help you inserting huge amounts of data:


use APPEND hint, this should solve your problem, as the data will go directly into the datafiles per-say.
try to break the data into smaller chunk, and insert them sequentally
use NOLOGGING mode to avoid frequent log-switchees (don't forget to enable it back afterwards!) - or at least increase the size of redo-log files
avoid using cursors
drop any indexes that you might have
try to COMMIT less frequently (use a transaction for each chunk of data, and commit at the end)


Hope this helps!