GA · v4.16SRC · *.dmp exportMAGIC 0x2815

Read Oracle dumps. Without Oracle.

Parse Data Pump .dmp files straight off disk. Tables, LOBs and embedded documents land in open formats — no import, no running DB, no Oracle code on the machine.

//What is verified here

28+ Oracle data types incl. native JSON, VECTOR & BOOLEAN (23ai+), TIMESTAMP WITH LOCAL TIME ZONE GA
LOB side-file extraction: 25+ magic-byte signatures, manifest.json with SHA-256 GA
BASIC / OLTP compression decoded · native OSON (26ai) byte-exact GA
HCC (Hybrid Columnar) in the dump — env-gated (RECLAIMDB_ALLOW_HCC=1), best-effort EXPERIMENTAL
KGC-compressed dump content — env-gated (RECLAIMDB_ALLOW_KGC=1), best-effort EXPERIMENTAL
Classic exp / imp dumps (pre-Data-Pump, Oracle 7–11g) — auto-detected and dispatched EXPERIMENTAL

Honest scope · HCC & KGC

HCC-compressed segments inside the dump are really decoded, but flagged best-effort and kept behind RECLAIMDB_ALLOW_HCC=1 — not cell-exact-validated against every LTS version. KGC content sits behind RECLAIMDB_ALLOW_KGC=1 the same way. For critical audits, verify with us beforehand.

//Step by step

Inspect the dump (without writing anything)

reclaimdb dmp-extract --info export01.dmp

Shows source-DB version, contained schemas/tables, compression and encryption status.

Extract tables into open formats

reclaimdb dmp-extract --csv ./out/ export01.dmp
# Targeted by schema/table, different target format:
reclaimdb dmp-extract --schema HR --table EMPLOYEES --json ./out/ export01.dmp

LOBs & embedded documents as side-files

Large BLOB/CLOB are written as real files; the cell carries the relative path. A manifest.json holds SHA-256, size and MIME type per file (detected via 25+ magic-byte signatures).

reclaimdb dmp-extract --csv ./out/ --lob-dir ./out/lobs/ export01.dmp
cat ./out/lobs/manifest.json   # sha256, size, mime per file

Encrypted dumps — a clean handoff

For ENCRYPTION dumps reclaimDB prints a diagnosis only and aborts fail-closed (exit 11). Password mode uses a proprietary KDF; in wallet mode the envelope unwraps (MKID → MEK → DEK) but Oracle derives the block-cipher key proprietarily on top — not derivable clean-room. The supported path:

# Diagnose
reclaimdb --dmp-wallet cwallet.sso dmp-extract --info enc.dmp
# Handoff: re-export with Oracle, then reclaimDB
impdp ... ; expdp ... ENCRYPTION=NONE

//Relevant exit codes

Success

Wrong magic / not a valid DMP

Encrypted dump without a derivable key (handoff needed)

Unsupported compression variant

Feature not byte-exact (fail-closed)

Test this case on your data

Send us the kind of source you actually have — a .dmp, a .dbf, an RMAN backup piece or a storage snapshot. You get a signed evaluation binary, a sample report, and an honest assessment of which paths apply to your case.

office@reclaimdb.com →