bash: expdp: command not found

Resolving “Command Not Found” Error for expdp and Performing Oracle Data Pump Export

Performing an Oracle Data Pump export is a common task for database administrators and developers. However, encountering a “command not found” error for expdp can be frustrating and hinder your progress. In this article, we'll walk you through the steps to resolve the "command not found" error for expdp by setting the correct environment variables and performing an Oracle Data Pump export.

Resolving “Command Not Found” Error for expdp

1. Locating Oracle Installation Directory

To locate the Oracle installation directory, you can use the find command:

find / -name oracle

2. Setting Oracle Environment Variables

Once you’ve located the Oracle installation directory, set the ORACLE_HOME and update the PATH environment variables accordingly:

export ORACLE_HOME=/u01/app/oracle/product/19/db
export PATH=$ORACLE_HOME/bin:$PATH

3. Verifying expdp Command Availability

Verify if the expdp command is now accessible by using the which command:

which expdp

Performing Oracle Data Pump Export

4. Performing Data Pump Export

Now that the expdp command is accessible, you can proceed with performing an Oracle Data Pump export:

expdp hh/test123@cbs_yol1 directory=dp_dir dumpfile=FULL_DB_07.dmp logfile=FULL_DB_07.log FULL=Y

Conclusion

Encountering a “command not found” error for expdp can be resolved by setting the correct ORACLE_HOME and updating the PATH environment variables to include the Oracle binary directory. Once the environment variables are correctly set, you can successfully perform an Oracle Data Pump export using the expdp command.

By following the comprehensive guide provided in this article, you can resolve the “command not found” error for expdp and perform Oracle Data Pump exports tailored to your specific requirements.