如何使用NOT EXISTS从数据链接表中插入记录

I have 4 remote locations and oracle express database installed. The locations create some transactions there and I want to run a job/procedure once in a day to insert the new records into a central table at our head office. The table structure of the head office and remote table is exactly same.I have 4 remote locations and oracle express da