The default Oracle installation for Linux didn't come with the expdp and impdp command line tools. I have trouble finding them on Oracle's website. How could I install them?

  • They were installed, just missing from my $PATH. See the answer below. – laurt Oct 4 '16 at 12:42

Data Pump utilities are installed automatically during the installation of Oracle Database. It should be working without any issues as long as the environment variables(PATH, ORACLE_HOME) are set properly. To set PATH and ORACLE_HOME variable permanently-

1) Log in as oracle user in the OS.

2) [oracle@ora12c Desktop]$ vi ~/.bash_profile

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1; export ORACLE_HOME

3)[oracle@ora12c Desktop]$ . ~/.bash_profile

4)Check the value of the variables.

[oracle@ora12c Desktop]$ echo $ORACLE_HOME
[oracle@ora12c ~]$ echo $PATH

5) Try to run expdp

[oracle@ora12c Desktop]$ expdp 

Export: Release - Production on Tue Oct 4 16:46:44 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


Setting Oracle Environment Variables


In my case I just needed to log in with "oracle" user instead of root. This user had all the environment variables correctly set.

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.