Originally posted by monna
Please do not take me wrong, I do not want to discover that the earth is round but is something that is missing.

You say that when:
create table as select * from table@remote has nothing to do with the rollback seg.
I think there is an “insert “ involved in this create table so there is a transaction.
How the data is “moved” into a new table?

thanks

I am not aware as to how this happens internally but you can do a small test

use the create table as select * from ... command and then issue a rollback . You will notice that the data is still there in the table which got created. Its not rolled back. This shows that there is no before image of the data.