3 Ways to Inspect Oracle DataPump (EXPDP) Dump File Contents
Need to check what's inside an Oracle Data Pump (expdp) dump file? Whether you're validating data before import or verifying a file you received, this is a common task.
This article covers three approaches depending on your situation.
Method 1: impdp SQLFILE Option (Requires Oracle)
If you have an Oracle Database environment, use the impdp utility with the SQLFILE parameter to extract DDL (CREATE statements) without actually importing.
impdp user/pass DIRECTORY=dump_dir DUMPFILE=export.dmp SQLFILE=ddl_output.sqlPros: Official Oracle method, highly reliable
Cons: Requires Oracle Database installation. Cannot view actual row data
Method 2: OraDB DUMP Viewer (No Oracle Required — Recommended)
With OraDB DUMP Viewer, you can inspect DMP file contents through an intuitive GUI without installing Oracle.
What You Can Inspect
- Schema structure — Hierarchical schema → table tree view
- Table data — Browse actual data with pagination
- DDL information — CHECK constraints, INDEX definitions, table/column comments
- LOB data — Preview and extract CLOB/BLOB content
- Partitions — Partition table structure and individual data
Steps
- Install OraDB DUMP Viewer (
winget install OraDBDumpViewer.OraDBDumpViewer) - Open your .dmp file
- Select a table in the left panel, view data in the right panel
- Export to CSV or SQL as needed
Pros: No Oracle needed. Intuitive GUI. View actual data
Cons: Windows only
Method 3: strings Command (Quick Emergency Check)
On Linux/macOS, the strings command can extract text strings from a dump file.
strings export.dmp | head -100This reveals fragments like table names and schema names, but cannot provide structural analysis.
Pros: Available on any OS with standard tools
Cons: Only fragments. No accurate data inspection
Comparison
| impdp SQLFILE | OraDB DUMP Viewer | strings | |
|---|---|---|---|
| Oracle Required | Yes | No | No |
| DDL Inspection | Yes | Yes | No |
| Row Data | No | Yes | Partial |
| GUI | No | Yes | No |
| Export | No | Yes (CSV/SQL/Excel etc.) | No |
| EXP Format | No | Yes | Partial |
| Cost | Oracle License | Free for personal use | Free |
Summary
For inspecting DataPump dump file contents, OraDB DUMP Viewer is the most convenient and practical choice. Skip the overhead of setting up an Oracle environment and browse everything from schema structures to actual row data through an intuitive GUI.