Error after adding a new Oracle Export Directory Location

Posted on 2014-08-28
Last Modified: 2014-08-28
Our test oracle server is running out of disk space so we mounted a usb drive on /mnt/usbflash named EXPDIR

I also granted read, write on directory to the user used in the export command line.

We can't get the Oracle Enterprise Manager running so I created the above directory through SQL

When I use
/opt/oracle/product/10.2/db_1/bin/expdp user/password@testsid SCHEMAS=schema1 DIRECTORY=EXPDIR LOGFILE=exp1.log DUMPFILE=exp1.dmp

when run this, I get these errors -
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

then it stops

I have 5 schemas to export so I want to do a full export but the file size will be around 18G and I only have 2G free space on our test Linux server.

Please help. I need to get this exported ASAP so we can do test on an upgrade.

Also after this test, I will be importing the live database into the same test server.

So I need help going both ways: expdp and impdp.

Thank you in advance!!!
Question by:goldieretriever
    LVL 34

    Accepted Solution

    does the user account have access permissions to that device?
    if you do ls -lh /mnt who is the owner?
    if you are using, say oracle user, try chown oracle /mnt/usbflash as root
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    It may be possible Oracle sees the USB drive as a NAS.

    There are specific mount options needed to allow Oracle to use a NAS.

    Check out the following doc (it is a 10gR1 doc but should be the same for 10gR2):
    NFS Mount Options

    Author Closing Comment

    Thank you for your quick response - this solution worked.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension ( This reminded me of questions tha…
    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now