dear tjhondro Di server database cek dulu tnsnams nya udah ada atau belom. kalau udah ada cek pake tnsping (db name alias)
database link nya sudah di buat belom mas.. coba cek database link nya ok ----- Original Message ----- From: "cyuniart" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, June 19, 2006 8:28 PM Subject: [indo-oracle] help me - connection database for remote database not found > Dear all, > Mohon bantuannya, > > ada 3 DB (X, Y, Z) > > dari user A di DB X dgn memakai dblink saya membuat view 'test_v' > untuk tabel yang ada di DB Y dan view 'test2_v' untuk tabel di DB Z. > > ketika saya coba insert dari user B(X) > > insert into test_v > select * from test2_v > > muncul error > > ORA-02019: connection description for remote database not found > ORA-02063: preceding line from X > ORA-02063: preceding 2 lines from Z > > tapi saat perintah itu dijalankan di user A (X), ternyata sukses. > padahal synonym dan grant yg diperlukan oleh B(X) sudah diberikan. > > mohon bantuannya, > o ya, saya memakai oracle 10g rilis 1. > > Thx sebelumnya, > tjhondro > > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > Mirror: http://indooracle.wordpress.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.com > Yahoo! Groups Links > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.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/
