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!

database link problem

User347578Oct 5 2011 — edited Oct 6 2011

Hi

can some one help me in providin some solution to this problem .

15:04:58 idle> create database link apexp_cirp connect to csr_apex_user identified by password using cir;
create database link apexp_cirp connect to csr_apex_user identified by passwordd using cir
*
ERROR at line 1:
ORA-02010: missing host connect string

I've connected to the user called cir_user on apex database and run thie above script.

i've also checked the tnsnames.ora file and the entry is there for cir

any suggestion is highly apprciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 3 2011

Added on Oct 5 2011

#general-database-discussions

2 comments

3,748 views