Create database link-SQL command not properly ended

Question

I have a script to create database link as following. But the script encounter errorORA-00933: SQL command not properly ended

CREATE DATABASE LINK "MIG_61_TO_74" CONNECT TO "ABC_DEV" IDENTIFIED BY 'ABC_DEV' USING 'info001:1521/orcl';

Phantom · Accepted Answer · 2018-04-10 08:31:47Z

2

Perhaps the are apostrophies confusing the parser. This example by Oracle doesn't include them, try it that way.

CREATE DATABASE LINK MIG_61_TO_74
   CONNECT TO ABC_DEV IDENTIFIED BY "ABC_DEV"
   USING 'info001:1521/orcl';

answered Apr 10, 2018 at 8:06

Phantom

3883 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Yes, the apostrophies confused!

If that answered your question, please mark my answer as "helpful". Thank you.

As ABC_DEV is the password you should enclose it by double quotes, i.e. "ABC_DEV", otherwise it will not be case-sensitive.

@WernfriedDomscheit Corrected. Thanks.