Original Export utility (exp)
Survived by a workaround.
draft notice, awaiting certification
In life
The original Export utility, exp, is the client-side program that reads a database over a session and writes a proprietary dump file; imp is its import counterpart. Data Pump (expdp and impdp) replaced the pair in 10g with a server-side, parallel design and a different dump-file format.
Migrations care because legacy runbooks and cron jobs still call exp for backups and schema copies. Its dump files cannot be read by Data Pump import, and neither format can be loaded directly into an Azure database service, so an inventory of "exports" must distinguish old-style dumps from Data Pump dumps before deciding what to keep.
Oracle's Utilities guide says original Export has been desupported for general use since 11g, with backward migration of XMLType data to 10.2 the only remaining supported use, and recommends Data Pump. The 26ai Upgrade Guide lists the utility itself as desupported (notice dated April 2023). Because the 11g statement is phrased as a limited desupport rather than a deprecation of a named release, no deprecation release is recorded here.
Cause of departure
Desupported in Oracle Database 26ai. Oracle names Data Pump Export (expdp) as the successor.
Survived by
SQL Server Migration Assistant for Oracle workaround effort M
The original Export utility produced legacy .dmp files that only imp could read; none of the Azure migration tools accept them. SSMA needs a live connection to the Oracle database, so old exp dumps must first be imported into an Oracle instance (any supported release, or Oracle Database@Azure) before SSMA, Ora2Pg or Data Factory can extract from it.
- Import legacy exp dumps into a staging Oracle database with imp.
- Point SSMA (or Ora2Pg / Data Factory) at the staging database.
- Retire exp-based nightly extracts in favour of Data Factory pipelines or SQL backups.
Notices of correction
- oracle Oracle Database Changes, Desupports, and Deprecations (Upgrade Guide 26ai) · Upgrade Guide 26ai, G43570-12, updated Jul 2026 · read 2026-09-26
- oracle Original Export (Utilities 19c) · Database Utilities 19c · read 2026-09-26
- oracle Overview of Oracle Data Pump (Utilities 19c) · Database Utilities 19c · read 2026-09-26
- microsoft SQL Server Migration Assistant for Oracle (OracleToSQL) · page updated 2026-04-24 · read 2026-09-26
- microsoft Azure Database Migration Service: supported migration scenarios · page updated 2026-02-20 · read 2026-09-26