Sepertinya karena parameter global_names di database server a nilainya TRUE. Akibatnya nama dblink harus sama dengan global_name di database tujuan.
Coba set parameter global_names = FALSE atau Buat dblink dengan nama ORACLE.WORLD : create database link ORACLE.WORLD connect to scott identified by tiger using 'SCOTT_SERVICE'; regards, tomi --- agus sulaiman <[EMAIL PROTECTED]> wrote: > Kepada teman-teman semuanya , > Saya telah membuat database link sebagai berikut > diserver a: > sql> connect scott/[EMAIL PROTECTED]; > sql> create database link SCOTT_LINK.world > connect to scott identified by tiger > using 'SCOTT_SERVICE'; > database link created > > kemudian saya tambahkan pada folder > net80/admin/TNSNAMES > SCOTT_SERVICE.world = > (description = > ( address = (protocol = tcp) > (host = serverb) > (port = 1521) > ) > ( connect_data = (sid=orcl)) > ) > setelah ini saya melakukan > sql> connect scott/[EMAIL PROTECTED]; > sql> select count(*) from [EMAIL PROTECTED]; > ERROR AT LINE 1: > ORA-02085 : DATABASE LINK SKA_LINK.WORLD CONNECTS TO > ORACLE.WORLD > > PERTANYAANYA ADALAH ERROR TERSEBUT MAKSUDNYA APA DAN > KESALAHANNYA > ADA DIMANA YA ? > MUNGKIN TEMEN-TEMEN PERNAH MENGALAMI ERROR SEPERTI > INI ? > > THANKS, > AGUS SULAIMAN > > > > --------------------------------- > Yahoo! Autos. Looking for a sweet ride? Get > pricing, reviews, & more on new and used cars. > > [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.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > [EMAIL PROTECTED] > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- 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/
