Ora- 39087 : Directory Name Data_dump_dir Is Invalid

[sonuji_in]

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

[julian]

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

[sonuji_in]

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

[sonuji_in]

thanks julian

there was a big blunder done by me
see in previous message
i have types data_pump_dir is a wrong way(spelling mistakes) ..
but now it is working fine
thanks my dear friend.
sonu

[sonuji_in]

thanks Julian
in my previous message see inspite of data_pump_dir i have typed data_pumo_dir ...thats why it was giving me problem
but now it is working fine
thanks my dear friend
sonu

[julian]

Originally posted by sonuji_in
thanks Julian
in my previous message see inspite of data_pump_dir i have typed data_pumo_dir ...thats why it was giving me problem
but now it is working fine
thanks my dear friend
sonu

thanks my dear friend?? :-))