Ora- 39087 : Directory Name Data_dump_dir Is Invalid
Hi Gurus
version : oracle 10g (10.1.0.2.0) for 32 bit windows
when ever i am trying to use this utility expdp from command line it gives me this error'
c:\oracle\product\10.1.0\Db_1\bin> expdp system/password full=y
ORA -39002 : INVALID OPERATION
ORA- 39070 : UNABLE TO OPEN THE LOG FILE
ORA- 39087 : DIRECTORY NAME DATA_DUMP_DIR IS INVALID
PLEASE GUIDE ME do i have to set some more parameter in init file
thanks in advance
sonu
Re: Ora- 39087 : Directory Name Data_dump_dir Is Invalid
Did you run first:
create directory data_pump_dir as 'C:\oracle';
Then run:
expdp system/password directory=data_pump_dir dumpfile=exp%U.dat full=y
still facing the same problem
thanks julian
I have tried this way but problem is still same
**************************************
C:\oracle\product\10.1.0\Db_1\BIN>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Jun 15 14:40:04 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SYS AS SYSDBA at master>create directory data_pumo_dir as 'C:\oracle';
Directory created.
SYS AS SYSDBA at master>commit;
Commit complete.
SYS AS SYSDBA at master>disc
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
at >exit
C:\oracle\product\10.1.0\Db_1\BIN>expdp system/oracle10g directory=data_pump_dir
dumpfile=exp%U.dat full=y
Export: Release 10.1.0.2.0 - Production on Tuesday, 15 June, 2004 14:41
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATA_PUMP_DIR is invalid
C:\oracle\product\10.1.0\Db_1\BIN>
****************************
please guide me
Sonu