1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

error in EXPDP

Discussion in 'Security, Backup and Recovery' started by mirza, Aug 5, 2009.

  1. mirza

    mirza Active Member

    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    80
    Dear Friendz,

    I am getting an error while running EXPDP.

    Please Help



    C:\>expdp user1/user1@harish full=y directory=test_dir dumpfile=expdp.dmp logfile=expdp.log



    Export: Release 10.2.0.4.0 – Production on Wednesday, 05 August, 2009 11:53:54

    Copyright (c) 2003, 2007, Oracle. All rights reserved.



    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    ORA-39002: invalid operation

    ORA-39070: Unable to open the log file.

    ORA-29283: invalid file operation

    ORA-06512: at “SYS.UTL_FILE”, line 488

    ORA-29283: invalid file operation



    Mirza
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    A key message is here:

    ORA-39070: Unable to open the log file.

    Apparently the oracle user has no permissions to write in the specified directory.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Check this link for the reason behind the error. Also chek this link for more details of Expdp and impdp.
     
    mirza likes this.