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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s