Hello agus,
Friday, February 17, 2006, 1:20:07 PM, you wrote:
as> Kepada teman-teman semuanya ,
as> Saya telah membuat database link sebagai berikut diserver a:
as> sql> connect scott/[EMAIL PROTECTED];
as> sql> create database link SCOTT_LINK.world
as> connect to scott identified by tiger
as> using 'SCOTT_SERVICE';
as> database link created
as> kemudian saya tambahkan pada folder net80/admin/TNSNAMES
as> SCOTT_SERVICE.world =
as> (description =
as> ( address = (protocol = tcp)
as> (host = serverb)
as> (port = 1521)
as> )
as> ( connect_data = (sid=orcl))
as> )
as> setelah ini saya melakukan
as> sql> connect scott/[EMAIL PROTECTED];
as> sql> select count(*) from [EMAIL PROTECTED];
as> ERROR AT LINE 1:
as> ORA-02085 : DATABASE LINK SKA_LINK.WORLD CONNECTS TO ORACLE.WORLD
as> PERTANYAANYA ADALAH ERROR TERSEBUT MAKSUDNYA APA DAN KESALAHANNYA
as> ADA DIMANA YA ?
as> MUNGKIN TEMEN-TEMEN PERNAH MENGALAMI ERROR SEPERTI INI ?
as> THANKS,
as> AGUS SULAIMAN
Oracle Product Document Library (C) Oracle Corporation
Manual: Database Error Reference: A90202-02
ORA-02085 database link string connects to string
Cause: The database link attempted to connect to a database with a different
name. The name of the database link must be the same name as the name of the
database.
Action: Create a database link with the same name as the database to which it
connects.
Semoga membantu
--
Best regards,
Rony
--
-----------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/
