That was my first thought but if I use :
create my_table
unrecoverable
as
select * from table@remote;

I will have a big transaction ,the commit will take place after all the 8,000,000 have been inserted.
Or I might be wrong?!!