[SOLVED] Seperate log path and dump path in expdp

Seperate log path and dump path in expdp

I have to run multiple exports in one of the Oracle 12c databases for which I am using PAR files. Now I want to put the dump file and the log file in separate paths while using expdp. Please guide me on how to achieve this

Solution

The DIRECTORY parameter

Specifies the default location to which Export can write the dump file set and the log file.

The DUMPFILE parameter and LOGFILE parameter each allow that default to overridden, by supplying an optional directory name:

DUMPFILE=[directory_object:]file_name [, ...]

LOGFILE=[directory_object:]file_name

So your parameter file needs to include those overriding directory names in the relevant parameters. Note that they still have to directory objects, defined in the database and which you have privileges against; you can't supply native operating systems paths directly in any of those parameters.