oracle的dump导入mysql_DUMP 导入导出

Direct export from Oracle dump files

Oracle dump file (.DMP) is a binary storage used by Oracle users and database administrators to backup data. Oracle distribution pack includes the standard tool EXP for this purpose. The problem is that Oracle dump file is a "black box" and there is no way to extract data from such files except the standard IMP tool. However, this utility can import data to Oracle server only. But what if you just need to access the data without Oracle database server? Or maybe you want to migrate Oracle dump file into another data format? Definitely, Oracle IMP tool is not a convenient solution for these tasks.

Even if you have live instance of Oracle server, there are a lot of possible issues you may experience when importing a dump file:

upward/backward compatibility of different Oracle versions

character set conversion when NLS_LANG parameter of the dump file is not the same as Oracle server settings

mapping data into another schema (it's necessary if structure of source Oracle database is different from the one stored in dump file)

Intelligent Converters have investigated Oracle dump format and released a collection of tools to read and export data to the most popular data sources. This is OraDump Export Kit, product to convert Oracle dump files into Microsoft SQL, Microsoft Access, Microsoft Excel, MySQL and CSV. It does direct reading from dump file, so Oracle components are not required. The product supports all versions of Oracle and has no limitations on file size. Fast algorithm of direct reading can process more than 5 GB per hour on average modern system.