Jika database nya sama-sama oracle.. pergunakan database link pak untuk bisa melakukan query antar database.
pertama yg harus dilakukan : 1. tambahkan list database di TNS ora 2. create database link sample untuk query pakai database link: select * from tablen...@database_link smoga membantu ________________________________ From: Jimmy Sinaga <[email protected]> To: [email protected]; [email protected] Sent: Sun, October 11, 2009 2:43:02 PM Subject: [indo-oracle] Query antara database di oracle Dear Oracle'ers, Ada yg pernah atau punya pengalaman melakukan query antar database. Misalnya : Table A di dlm database A Server A dan IP A , Table B di dlm database B server B dan IP B Bagaimana cara query nya antar database tsb dimana kita berada di database A? Mohon petunjuknya -- Thanks and Regards, Jimmy Sinaga [Non-text portions of this message have been removed] __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
