0

I have an Oracle 11g database on a RedHat server and also have MySQL database on another RedHat server. I want to create a link to the MySQL server from the Oracle which allows me to execute queries in MySQL from Oracle.

Is this possible?

2

Oracle can connect to MySql with an ODBC connector. This is described in some detail here. Also see the official Oracle documentation here.

This will work for Oracle 10 and 11g to MySQL 4.1, 5.0, 5.1 or 6.0. There are limitations both in performance and what you can do. My understanding is

  • no distributed transactions
  • no insert as select .....
  • treat numbers as numbers and strings as strings, this is not the place for implicit type casts
  • as you might expect non-Oracle features are not supported
  • no Oracle DDL is supported
  • these functions are supported AVG(exp), LIKE(exp), COUNT(*), MAX(exp), MIN(exp), NOT
1

I think the only way to do that is to write a UDF in Java. Oracle itself won't be able to connect to a MySQL server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.