Configure a Data Pump Directory for Local Installations

If your system is set up as a local standalone or local cluster, you need to manually specify the data pump directory. The data pump directory is used in the backup and restore process for the Oracle database.

1. Connect to the Oracle database as the sysdba.

   cd $ORACLE_HOME/bin
   ./sqlplus / as sysdba

2. Change the directory location of the data pump files to your desired directory.
   Below is an example of the command.

   CREATE OR REPLACE DIRECTORY "DATA_PUMP_DIR" as '/home/oracle/app/oracle/product/12.2.0/dbhome_1/rdbms/log/';

3. Verify the change took place.

   SELECT owner, directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR';