solusi simpelnya create database link tes connect to hmsexim identified by "hmsexim" using 'TST2' untuk nguji tes koneksinya select * from [EMAIL PROTECTED] TST2 artinya koneksi yang di pake untuk akses ke table tujuan pada database remote tst2 ini sama dengan connection string mudah2ahn solved
SETIJO AGUS <[EMAIL PROTECTED]> wrote: aku kirim lewat japri pdf langkah - langkah waktu aku bikin dblink > -----Original Message----- > From: Jack Mania [SMTP:[EMAIL PROTECTED] > Sent: Thursday, March 03, 2005 9:06 AM > To: [email protected] > Subject: [indo-oracle] RE: Data Base Link > > Sebelumnya saya ucapkan terima kasih Pak, sudah berbagi ilmunya disini. > Cuma saya masih ada masalah Pak, sesudah Tnsnames saya tambahin, dan > database link saya buat, trus create public dengan sintaks seperti yang > dikasih (di server A). Saya connect user/pwd ternyata koq masih belum mau > membaca tabel di server B ya. Apa masih ada step yang kurang ya Pak? > Dan kalo boleh tau Pak, create public dg connect by ini berarti hanya user > yang kita definisikan saja yang bisa connect atau ini sudah mewakili semua > user di server A. > Mohon pencerahannya Pak, terima kasih. > > Regads, > > Andi > > > -----Original Message----- > Date: Tue, 1 Mar 2005 16:30:23 +0700 > From: SETIJO AGUS <[EMAIL PROTECTED]> > Subject: RE: Data Base Link > > gunakanlah dblink, langkahnya : > 1. di server A, buatlah tambahan tnsnames yang mengaksese server B, > misalnya > serverb = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = > (PROTOCOL = TCP) > (HOST = 172.20.140.197) > (PORT = 1521)) > ) > (CONNECT_DATA = > (SID = serverb) > ) > ) > > 2. buatlah perintah sql, misal login scott/tiger di server a > CREATE PUBLIC DATABASE LINK server_b CONNECT TO SCOTT IDENTIFIED BY > TIGER > USING 'server_b'; > > > > -----Original Message----- > > From: Jack Mania [SMTP:[EMAIL PROTECTED] > > Sent: Tuesday, March 01, 2005 4:22 PM > > To: [email protected] > > Subject: [indo-oracle] Data Base Link > > > > Hallo teman-teman, > > Saya mempunyai data base di 2 server yang berbeda. > > Sekarang ada tabel di data base A yang ingin digunakan > > oleh data base B. > > Pertanyaan saya gimana biar data base A ini bisa membaca > > data base B, dan bisa manipulasi data (SELECT, INSERT, UPDATE, > DELETE). > > O iya perlu diketahui, data base ini menggunakan Oracle 8i. > > Terima kasih atas sharing dan bantuan dari semuanya. > > > > Regards, > > > > Andi > > > > --------------------------------- > Celebrate Yahoo!'s 10th Birthday! > Yahoo! Netrospective: 100 Moments of the Web > > [Non-text portions of this message have been removed] > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: <http://indo-oracle.blogspot.com> > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > <http://indo-thin.vze.com> > > > > Yahoo! Groups Sponsor > ADVERTISEMENT > click here > <http://us.ard.yahoo.com/SIG=1295j5iql/M=298184.6018725.7038619.3001176/D= > groups/S=1705007183:HM/EXP=1109901963/A=2593423/R=0/SIG=11el9gslf/*http:// > www.netflix.com/Default?mqso=60190075> > > <http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/ > S=:HM/A=2593423/rand=240225075> > > _____ > > Yahoo! Groups Links > > > * To visit your group on the web, go to: > <http://groups.yahoo.com/group/indo-oracle/> > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/>. > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
