Tony, i agree with that .

My query is how will i make sure that transactions are not going to redolog when i use UNRECOVERABLE option .

My sql statement is like this .

Insert into <tableA>
select
col1,
col2,
col3
from <tableB>@dblink UNRECOVERABLE;

Thanks
tom