Originally posted by monna
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?!!

You dont have to worry about commit/rollback because its a DDL.

No rollback will be generated for this.

Hope this helps