SQL> create table ttt as select level lv,rownum rn from dual connect by level<10000000;
create table ttt as select level lv,rownum rn from dual connect by level<10000000
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 48 bytes (kxs-heap-w,cursor work heap)