oracle-databasesqlplusdatapumpimpdpexpdp

SQLPlus - Data Pump (expdp and impdp)


some time ago, I installed Oracle SQLPlus without full Oracle database package. Now I need expdp and impdp utility. Is it possible to copy important files from a full Oracle installation and pasting them into SQLPlus directory?

Or maybe is there any other option to install only expdp and impdp? (Windows)

Regards, Kamil


Solution

  • Not really.

    But, you don't have to actually 'Install' the full client.

    Our latest distribution includes an Instant Client with sql*loader and data pump utilities.

    Grab this one

    Instant Client Package - Tools: Includes Data Pump, SQLLoader and Workload Replay Client*

    There's no installer. Just unzip it, and add the directory to your PATH. You should be good to go then.

    I wouldn't dump the files into your existing directory where you have SQLPlus though, just put it in a fresh directory and use that instead of your old one.