The .dmp is a dump of a table built in Oracle 10g (Express Edition) and one of the fields is of CLOB type.
.dmp是在Oracle 10g（Express Edition）中构建的表的转储，其中一个字段是CLOB类型。
I was trying to simply export the table to xml/csv files then import it to the MySql, but the export simply ignored the CLOB field... (I was using sqldeveloper for that).
我试图简单地将表导出到xml / csv文件然后将其导入MySql，但导出只是忽略了CLOB字段...（我之前使用的是sqldeveloper）。
I noticed this post explaining how to extract the CLOB to text file but it seems to miss the handling of the other fields or at least the primary key fields. can it be adopted to create a csv of the complete table? (I am not familiar with plsql at all)
我注意到这篇文章解释了如何将CLOB提取到文本文件，但似乎错过了对其他字段或至少主键字段的处理。是否可以通过创建完整表的csv？ （我根本不熟悉plsql）
As the brute force approach, I can use my python interface to simply query for all the records and spool it to a flat file but I'm afraid it will take a LOOOONG time (query for all records replace all native commas with the ascii... )
随着蛮力的方法，我可以使用我的python接口简单地查询所有记录并将其假脱机到一个平面文件，但我担心它将需要一个LOOOONG时间（查询所有记录用ascii替换所有本机逗号。 ..）
Thanks guys!
多谢你们！
3 个解决方案
#1
6
if you can get the mysql server and the oracle server on the same network, you might want to look at the mysql administrator tools, which includes the migration toolkit. you can connect to the oracle server with the migration toolkit and it will automatically create tables and move data for you.
如果您可以在同一网络上获取mysql服务器和oracle服务器，您可能需要查看mysql管理员工具，其中包括迁移工具包。您可以使用迁移工具包连接到oracle服务器，它将自动为您创建表并移动数据。
#2
3
Here is a documentation explaining the migration process: http://www.mysql.com/why-mysql/white-papers/mysql_wp_oracle2mysql.php
这是一个解释迁移过程的文档：http：//www.mysql.com/why-mysql/white-papers/mysql_wp_oracle2mysql.php
and you can use Data Wizard for MySQL . Trial version is fully usable for 30 days.
你可以使用MySQL的数据向导。试用版可完全使用30天。
#3
3
After about 2 hours of installing and uninstalling the MySql on the same machine (mylaptop) in order to use the migration tool kit as suggested by longneck, I decided to simply implement the dump and here it is for the likes of me that have minimal admin experience and get hard time to make both DBs work together (errors 1130, 1045 and more).
在同一台机器（mylaptop）上安装和卸载MySql大约2个小时后，为了使用longneck建议的迁移工具包，我决定简单地实现转储，这里是我最喜欢的管理员经验并且很难让两个DB一起工作（错误1130,1045等）。
Surprisingly, it is not as slow as I expected: OraDump
令人惊讶的是，它没有我预期的那么慢：OraDump
Any comments and improvements are welcomed.
欢迎任何评论和改进。
#1
6
if you can get the mysql server and the oracle server on the same network, you might want to look at the mysql administrator tools, which includes the migration toolkit. you can connect to the oracle server with the migration toolkit and it will automatically create tables and move data for you.
如果您可以在同一网络上获取mysql服务器和oracle服务器，您可能需要查看mysql管理员工具，其中包括迁移工具包。您可以使用迁移工具包连接到oracle服务器，它将自动为您创建表并移动数据。
#2
3
Here is a documentation explaining the migration process: http://www.mysql.com/why-mysql/white-papers/mysql_wp_oracle2mysql.php
这是一个解释迁移过程的文档：http：//www.mysql.com/why-mysql/white-papers/mysql_wp_oracle2mysql.php
and you can use Data Wizard for MySQL . Trial version is fully usable for 30 days.
你可以使用MySQL的数据向导。试用版可完全使用30天。
#3
3
After about 2 hours of installing and uninstalling the MySql on the same machine (mylaptop) in order to use the migration tool kit as suggested by longneck, I decided to simply implement the dump and here it is for the likes of me that have minimal admin experience and get hard time to make both DBs work together (errors 1130, 1045 and more).
在同一台机器（mylaptop）上安装和卸载MySql大约2个小时后，为了使用longneck建议的迁移工具包，我决定简单地实现转储，这里是我最喜欢的管理员经验并且很难让两个DB一起工作（错误1130,1045等）。
Surprisingly, it is not as slow as I expected: OraDump
令人惊讶的是，它没有我预期的那么慢：OraDump
Any comments and improvements are welcomed.
欢迎任何评论和改进。