Is “imp” still supported in Oracle Database 12.2?

exp imp

Good question we receive quite often:

Is “imp” still supported in Oracle Database 12.2?

For clarification: I don’t talk about “impdp” but about old “imp” (import). And yes, it is still supported in Oracle 12.2.

The oldexp” got desupported with Oracle Database – but “imp” is still supported, even in Oracle Database 12.2.0.x. You should be able to import your old dumps into the newest release of the database and migrate even VERY old releases directly to Oracle Database 12.2.

Actually, the biggest step upwards we’ve heard about a year ago was an exp from Oracle V5 and migration into Oracle Single Tenant. No joke – and it worked!

Only real pitfall we are aware of right now: The MOS Note 132904.1 (Compatibility Matrix for Export And Import Between Different Oracle Versions) hasn’t been updated recently for whatever reason.


2 thoughts on “Is “imp” still supported in Oracle Database 12.2?

  1. After upgrade performance on the following went from 3 minutes to over 25 minutes:


    Terrible performance on Oracle still. This was running in three minutes before with over 3 million rows, this was run on SE2 pulling from Oracle EE.

    • Colleen,

      are you saying the import via NETWORK_LINK took 3 minutes before (which release to which release) and now takes 25 minutes (which release to which release)?
      And isn’t out yet – do you mean If yes, what is your Bundle Patch Level? And did you apply the ADAPTIVE patches I have linked and recommended from the blog? Of if you can’t apply them, did you set any special init.ora parameters yet?


Leave a Reply

Your email address will not be published. Required fields are marked *