Thank you for the info.

I could able to create a table with UNRECOVERABLE option
but i am not able to insert records with unrecoverable option .

I use the below syntax

Insert into table1
values(col1,col2)
Unrecoverable
select col1,col2 from table2@dblink;

Is there any way to insert records with unrecoverable option?

Thanks
Tom