ORA-02010: missing host connect string

Cause:

Silly ! Connection string and password should be placed inside quotes

SQL> create database link dblink_prod_qa connect to test identified by password using orcl19x;
create database link dblink_prod_qa connect to test identified by password using orcl19x
                                                                                 *
ERROR at line 1:
ORA-02010: missing host connect string

Solution:

SQL> create database link dblink_prod_qa connect to test identified by "password" using 'orcl19x';

Database link created.

Leave a Reply