mas heri dan mas henri,
dblink sudah ada, grant dan synonym yg diperlukan juga sudah dibuat..
dari B(X) saya jalankan perintah 'select * from test_v' sukses.
begitu juga saat 'insert into test2_v select * from test' juga sukses.
(note : test_v = view ke database Y
test2_v = view ke database Z
test = tabel milik B(X))
view test_v dan test2_v milik user A(X)
(note : dblink tidak public, view hanya di grant select, insert,
update, delete ke B(X)).
jadi user B(X) ini hanya sebagai penghubung transaksi dari 2 db yg
berbeda.
--- In [email protected], Heriyanto KO <[EMAIL PROTECTED]> wrote:
>
> Coba test koneksi dblink via OEM kalo sudah sip? berarti masalahnya
bukan di dblink
> kalo dblinknya gak connect coba setting NET MANAGENYA khususnya
service naming. mungkin bisa via Net Manager. pengalaman saya, harus
hati2 dalam mendefinisikan setiap parameter2nya.
>
> good luck bro
>
>
> henriap <[EMAIL PROTECTED]> wrote:
> 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! Sports Fantasy Football '06 - Go with the leader. Start your
league today!
>
> [Non-text portions of this message have been removed]
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/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/
