I used this command to export data:

expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW

Now importing this to other server as:

[root@linux gsw]# impdp gsw/password remap_tablespace=SYSTEM:GSW remap_tablespace=USERS:GSW dumpfile=GSW-31-08-2018.dmp directory=gsw

Import: Release - Production on Sat Sep 1 11:17:47 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Express Edition Release - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/u01/app/oracle/admin/XE/dpdump/gsw/GSW-31-08-2018.dmp" for read

ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9

I googled but not able to fix it. Please advise

Thanks in anticipation

closed as off-topic by Colin 't Hart, hot2use, Marco, mustaccio, RDFozz Sep 4 '18 at 18:07

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Colin 't Hart, hot2use, Marco, mustaccio, RDFozz
If this question can be reworded to fit the rules in the help center, please edit the question.


The main issue is Linux-x86_64 Error: 13: Permission denied

cd /u01/app/oracle/admin/XE/dpdump/
 chmod 777 -R gsw

Then login as oracle user and run the same command again

Not the answer you're looking for? Browse other questions tagged or ask your own question.