Oracle Database Discussions

HI,

This question isn't about the SQL or PL/SQL languages, so the SQL and PL/SQL forum isn't a good place for it.

Ill move the thread to the General Database forum.

3696948 wrote:

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

unwilling or incapable to use GOOGLE yourself.

Let me assist

LMGTFY

How does Oracle DB know that the target of this DBLink is NOT an Oracle DB & is a MYSQL database?

>CREATE DATABASE LINK "MYDATABASE.MYSQL.xyzxyz.COM"

Hi,

The simple answer for your simple questions is: Yes, oracle supports database links to MySql.

The point is: You cannot do it just that way by creating a database link with the creation command. There are some configurations you should do to accomplish this task which depends on your oracle installation and environment you have.

Regards,

This will help:

How to connect Oracle DB to Mysql DB

https://oracle-base.com/articles/mysql/mysql-connections-in-sql-developer