Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Urgent (Database Link error ORA-02085)

447528Nov 17 2005 — edited Nov 4 2009

Hi All,

I am getting ORA-02085: database link CONTRACT_ACHIVE.US.ORACLE.COM connects to DATAWARE.US.ORACLE.COM.

I am using Oracle 8i. And try to make the connection between two different user within a single DB using DB LINK.

Global_Name = DATAWARE.US.ORACLE.COM

Using :

CREATE DATABASE LINK contract_achive
CONNECT TO temp
IDENTIFIED BY temp
USING 'Dataware';

How do i solve this problem? Please help.

Mani

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2009

Added on Nov 17 2005

#general-database-discussions

6 comments

1,049 views