oracle-databaseora-00933

Create database link-SQL command not properly ended

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';

Solution

  • 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';