Oracle's Simple data synchronization

--Create Target library dblinkcreate database link target library connect to account identified by "password" using ' IP Address: port/target library '; --Query created Dblinkselect owner,object_name from dba_objects where object_type= ' DATABASE LINK ';--Verify Dblinkselect * from [email  Protected] Target library; Synchronize data merge into table in Target library b USING Source Library table A on (b.id=a.id) when matched then update set B.name=a.name, ... when not Matched then insert values (a.name, ...) WHERE a.xx= ' xx '; Commit commit;

Oracle's Simple data synchronization