如何将.dmp文件（Oracle）导入到MySql DB？ [英] How to import a .dmp file (Oracle) into MySql DB?

问题描述

.dmp是Oracle 10g（Express Edition）中内置的表的转储，其中一个字段是CLOB类型的。

The .dmp is a dump of a table built in Oracle 10g (Express Edition) and one of the fields is of CLOB type.

我试图将表导出为xml / csv文件，然后将其导入到MySql中，但导出会忽略CLOB字段...（我正在使用sqldeveloper）。

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).

我注意到这个 post ，解释如何将CLOB提取为文本文件，但似乎错过处理其他字段或至少主键字段。可以采用创建完整表的csv吗？ （我根本不熟悉plsql）

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)

作为蛮力的方法，我可以使用我的python接口来简单地查询所有的记录，并将其拖放到一个单位文件，但我恐怕会花上一个LOOOONG时间（查询所有记录替换所有本地的逗号与ascii ...）

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... )

谢谢你们！

推荐答案

在同一台机器（mylaptop）上安装和卸载MySql大约2个小时后，为了使用longneck建议的迁移工具包，我决定简单地实施转储，这里是为了拥有最少的管理经验的我喜欢的人，并且花费很长的时间使两个DB一起工作（错误1130,1045以及更多）。

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).

令人惊讶的是，它并不像我预期的那么慢： OraDump

Surprisingly, it is not as slow as I expected: OraDump

欢迎任何意见和改进。

这篇关于如何将.dmp文件（Oracle）导入到MySql DB？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！