I have given Append hint in the insert query which is loding data from remote DB,eventhough the time taken by the insert query is not reduced.
The table in which I am inserting is not having more than 2 indexes.
There select statment with union all is loading data from remote DB which is inserting 29000 records.Explain plan is using nested loops and index scan.
the select alone is taking seconds. but the insert is taking 2 mitues.

thanks in advance