[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Error after adding a new Oracle Export Directory Location

Posted on 2014-08-28
Medium Priority
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 36

Accepted Solution

Seth Simmons earned 2000 total points
ID: 40291185
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 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40291211
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

ID: 40291338
Thank you for your quick response - this solution worked.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Suggested Courses
Course of the Month19 days, 12 hours left to enroll

873 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