Hello,
I created database link in oracle for My SQL Database. When I tried to test the database link it throw an error shown in the screen shot below. I was successfully created db links, synonyms for various databases in oracle in the past. However, when i execute below SQL Query it throws error.
CREATE DATABASE LINK "MYDATABASE.MYSQL.xyzxyz.COM"
CONNECT TO ABC_EFG_USER IDENTIFIED BY "******";
My question is does oracle support creation of database link for MY SQL.
Thanks,
Nawaz