Need to supply DATA_PUMP_DIR parameter when using expdb ?
593075Aug 29 2008 — edited Aug 29 2008Hello,
using oracle 10.2.1 on windows.
when setting a environment variable DATA_DUMP_DIR to the value dpdir (dpdir is an existing DIRECTORY inside the database which points to a valid location on the os-filesystem) i get an error when trying to execute expdp the following way:
C:\Dokumente und Einstellungen\ppp>expdp dptest/dptest logfile=xzy.log
Export: Release 10.2.0.1.0 - Production on Freitag, 29 August, 2008 10:51:45
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
uction
With the Partitioning, OLAP and Data Mining options
ORA-39002: Ung³ltiger Vorgang
ORA-39070: Log-Datei kann nicht ge÷ffnet werden.
ORA-39087: Verzeichnisname dpdir ist ung³ltig
However, when i add the DIRECTORY parameter to the expdp call and use dpdir als directory name, everything works.
As far as i understand the UTILITIES Guide from oracle it should be sufficient to use the environment variable mentioned above to
set the directory for data pump export...