如何在MySQL中创建数据库链接以连接到Oracle? [英] How to create a database link in MySQL to connect to Oracle?

问题描述

我需要在MySQL中创建数据库链接以连接到Oracle数据库，以使用Oracle数据库中存在的表.

I need to create a database link in MySQL to connect to an Oracle database to use a table present in the Oracle database.

我找不到在MySQL中创建数据库链接的任何代码或方法.我该怎么办?

I am not able to find any code or method of creating a database link in MySQL. How could I do this?

推荐答案

您可以通过Perl DBIx :: MyServer代理使用MySQL Federated表直接从MySQL内部访问Oracle(或其他DBMS)信息.此方法自2007年左右开始出现:有关此设置和用法的详细逐步说明，请参见: http://ftp.nchu.edu.tw/MySQL/tech -resources/articles/dbixmyserver.html 本文不仅演示了直接在MySQL中使用"select"语句到postgres和sqlite本机表的方法，还演示了如何使用直接在MySQL环境中执行的查询将其插入这些表中. 可在此处使用Perl模块: http://search .cpan.org/〜philips/DBIx-MyServer-0.42/lib/DBIx/MyServer.pm 祝你好运！

You can access the Oracle (or other DBMS) information directly from within MySQL using the MySQL Federated tables via the Perl DBIx::MyServer proxy. This method has been around since about 2007: a good step-by-step write-up of the set-up and usage is available here: http://ftp.nchu.edu.tw/MySQL/tech-resources/articles/dbixmyserver.html The write-up demonstrates not only the usage of 'select' statements from directly within MySQL to postgres and sqlite native tables, but also inserts back into those tables, using queries executed directly from within the MySQL environment. The Perl module is available here: http://search.cpan.org/~philips/DBIx-MyServer-0.42/lib/DBIx/MyServer.pm Good luck!

这篇关于如何在MySQL中创建数据库链接以连接到Oracle?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！