Question: I want to be able to specify the
directory for a data pump export (expdp
in UNIX/Linux.
What is the syntax to redirect a dmp file?
Answer: There is an easy way to use the DUMPFILE
argument in your parameter file for expdp:
DUMPFILE [DIRECTORY_NAME:]FILE_NAME
[, ...]
This parameter specifies the name (and
optionally the directory) of the export data file. You
may have to create the directory in Oracle with the "create
directory" command":
expdp
scott/tiger schemas=SCOTT directory=TEST_DIR dumpfile=MYDIR:myfile.dmp
logfile=expdpSCOTT.log
You can
also export with
across a database link.
and the
network_link parameter.