Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to import the Oracle database into MySQL in Navicat. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article.

one。 Download and activate Navicat

Omit

two。 View Oracle version

You need to download the OCI interface file according to the version and number of digits of Oracle, otherwise it will not take effect (key)!

Execute Select * from v$version in Sqllite or PlSQL to view version information

three。 Download the Oracle-enabled interface file for Navicat

According to the version of Oracle found in the previous step, download the same or similar version, if it does not take effect, download a few more similar versions to try.

Download address of OCI file 32-bit: http://www.oracle.com/technetwork/topics/winsoft-085727.html

Click download win64 bit click download: http://www.oracle.com/technetwork/topics/winx64soft-089540.html

four。 Configure the OCI environment for Navicat

Open tools-> options-> Environment:

In SQL*Plus, select the Oracle installation directory BIN\ sqlplus.exe

In the OCI environment, select the oci.dll file in the file downloaded in the previous step

Save and restart Navicat will take effect!

five。 Test Navicat connection to Oracle database

six。 Export Oracle database to Mysql

Select tools-> data transfer:

Create a Mysql database in advance, and then select the source as the Oracle database and the target as the Mysql database:

Select the table you want to export, and then click start:

Export succeeded:

Note: the date type is different in Mysql and Oracle databases. The date in oracle corresponds to the DATETIME of MysQL. If there is a problem, modify the field type in the database and then import it.

The above is how to import the Oracle database into MySQL in Navicat. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.