Keyword: Oracle to MySQL, Oracle to MySQL
Okay, try it. Navicat family's new product Navicat Premium, he integrates Oracle, MySQL and PostgreSQL management as one, personal feeling very strong (feel Fast)!
On the whim, can oracle import MySQL? Try it first:
1) New Oracle connection and MySQL connection
2) data transfer with tools (e.g.)
3) point start, import altogether started
Import finished, look at the effect of the import, very good, but there are some problems, need to manually change:
1) Oracle autogrow fields are generally controlled by "sequence", so the auto-grow fields that are imported seem to have no autogrow properties
2) Primary key, index, etc. may also be imperfect
3) Coding problem, Navicat Premium export data by default appears to be the utf-8 format, specific MySQL and Oracle code at your discretion
Overall very good, change it yourself
Oracle to MySQL latest effective method