Today, I need to sync data of different schema in same SID (same database). Honestly, I'm not very good at Oracle but I gotta develop this kind of project. That's why I've asked in StackOverFlow and @Luck Woodwords and he replied good solution.

http://stackoverflow.com/questions/9452488/how-to-create-oracle-dblink-in-same-sid#comment11957843_9452488

[More]