Ora- 39087 : Directory Name Data_dump_dir Is Invalid
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Ora- 39087 : Directory Name Data_dump_dir Is Invalid

  1. #1
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    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

  4. #4
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108
    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

  5. #5
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108
    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

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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?? :-))
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width