Converters for Microsoft SQL Converters for MySQL Converters for IBM DB2 Converters for MS Access Converters for Adobe PDF Converters for DBase/FoxPro Converters for Microsoft Excel Converters for Oracle Converters for Postgres MSSQL-to-Excel Converter MSSQL-to-MySQL Converter Intelligent Converters Software Access-to-MySQL Converter
export from oracle dump file, read oracle dump, convert oracle dump to access, convert oracle dump to excel, convert oracle dump to mysql, dmp
FAQ  |  Site map  |  Contact Us
About Us How to Buy All Products Discounts Migration Service Support Become a Partner Articles

How to export data from Oracle dump files directly

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 may be 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 CSV. It does direct reading from dump file, so Oracle components are not required. The product supports all versions of Oracle and has no limitaions on file size. Fast algorithm of direct reading can process more than 5 GB per hour on average P-IV system.

Other Features

  • All versions of Oracle dump files are supported (created by EXP and EXPDP tools)
  • Converts multi-file Oracle dump files
  • Option to convert individual tables
  • Stores conversion settings into profile
  • Command line support

Like each of Intelligent Converters products, OraDump Export Kit has features limited demo version. It converts five records for each table. Full version pricing starts at only $149.

You can find more details about OraDump Export Kit on the product page http://www.intelligent-converters.com/ordekit.htm