create table cux_bigtable(id1,id2) as 
select rownum as id1,1 id2
from dual
connect by level <= 1000000;

insert into cux_bigtable(id1,id2) select id1,id2+10 from cux_bigtable;