ORA-30009: Not enough memory for CONNECT BY operation

create table tq84_100_000_records as
select
   level  id,
   lpad('x', 1000, 'x') val
from
   dual connect by level <= 1e7;