Oracle-11g-R2
ORA-39001:ORA-39000:ORA-31640:ORA-27041:和 Linux-x86_64 錯誤:13:權限被拒絕
我使用此命令導出數據:
expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW
現在將其導入其他伺服器:
[root@linux gsw]# impdp gsw/password remap_tablespace=SYSTEM:GSW remap_tablespace=USERS:GSW dumpfile=GSW-31-08-2018.dmp directory=gsw Import: Release 11.2.0.2.0 - 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 11.2.0.2.0 - 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
我用Google搜尋但無法修復它。請指教
感謝期待
主要問題是
Linux-x86_64 Error: 13: Permission denied
cd /u01/app/oracle/admin/XE/dpdump/ chmod 777 -R gsw
然後以 oracle 使用者身份登錄並再次執行相同的命令