oracle 参数值无效，“目录”
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21182196/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
invalid value for parameter, 'directory'
提问by Maven
I am trying to import a datadump using impdputility and who command is as follows:
我正在尝试使用impdp实用程序导入数据转储，who 命令如下：
IMPDP project/project DIRECTORY=e:\_workline\workspace\rfc_16012014\project_staging DUMPFILE=project_staging.dmp LOGFILE=project_staging_log.log;
But i get this error on running this command:
但是我在运行这个命令时遇到这个错误：
UDI-00014: invalid value for parameter, 'directory'
However the value passed to DIRECTORYparamter is correct as in if i paste the given path in i.e. e:\_workline\workspace\rfc_16012014\project_stagingin the explorer window it will take me to the intended directory.
但是，传递给DIRECTORYparamter的值是正确的，因为如果我将给定的路径粘贴到 iee:\_workline\workspace\rfc_16012014\project_staging中的资源管理器窗口中，它将带我到预期的目录。
I hope the case of path string doesnt matter? e:\and E:\are same?
我希望路径字符串的大小写无关紧要？e:\和E:\一样吗？
Can anyone please help with this?
任何人都可以帮忙吗？
回答by Dba
You need to create a directory in the database instead of pointing the physical directory path for datapump exportand import.
您需要在数据库中创建一个目录，而不是指向 datapumpexport和import.
Assuming that you have the necessary privilege to create a directory
假设您具有创建目录所需的权限
CREATE OR REPLACE DIRECTORY <directory_name> AS 'e:\_workline\workspace\rfc_16012014\project_staging';
Then grant permission to user to read and write on that directory,
然后授予用户对该目录的读写权限，
GRANT READ, WRITE ON DIRECTORY <directory_name> TO project;
Mention the created directory name into your Import command and try,
在导入命令中提及创建的目录名称并尝试，
IMPDP project/project DIRECTORY=<directory_name> LOGFILE=project_staging_log.log dumpfile=<DMP_FILE>
Refer herefor more in detail.
