0

While importing or exporting oracle data dump using SQL Developer by default it is using impdp command for import and expdp command for export. But I want to import a dump which is exported using exp command, and for that i need to force SQL developer to use imp command instead of impdp command. And same for export.

Pleas help me if anyone knows how to in-force SQL developer to use imp for import instead of impdp and exp for export instead of expdp

1

Not going to happen

The Original exp utilitie became DESUPPORTED as of 11.1. Additionally, the 11.1 version of the database is no longer supported either. SQL Developer isn't going to be "patched" to support unsupported Database version or unsupported database features.

For more information you can read the Compatibility Matrix for exp/imp which has Oracle Doc ID 132904.1 NOTE : You must have a valid support contract (and account) to access the Document. (copy+pasting information is against Oracle's term of use)

The imp utility seems to still be around for importing old exports.

Workaround

Learn to use the command line.

  • Have you thought about using the exp/imp utilities directly in the Oracle Home? Ideally you want to use data pump, but if you really want to use the original export/import try doing it from the command prompt. You can also try to find a really old version of SQL Developer. – Gandolf989 Apr 16 at 19:00
  • The imp tool is here to stay for the foreseeable future. And the exp tool is also still available (in 18.3 and 19.1) and works just fine. – Albert Godfrind Apr 18 at 6:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.