Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 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
share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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