参数“目录"的值无效 [英] invalid value for parameter, 'directory'

问题描述

我正在尝试使用impdp实用工具导入数据转储，并且谁的命令如下:

I am trying to import a datadump using impdp utility and who command is as follows:

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'

但是传递给DIRECTORY参数的值是正确的，就像我将给定路径粘贴到资源管理器窗口中的e:\_workline\workspace\rfc_16012014\project_staging中一样，它将带我到预期的目录.

However the value passed to DIRECTORY paramter is correct as in if i paste the given path in i.e. e:\_workline\workspace\rfc_16012014\project_staging in the explorer window it will take me to the intended directory.

我希望路径字符串的大小写没有关系吗? e:\和E:\相同吗?

I hope the case of path string doesnt matter? e:\ and E:\ are same?

任何人都可以帮忙吗?

推荐答案

您需要在数据库中创建目录，而不是为datapump export和import指向物理目录路径.

You need to create a directory in the database instead of pointing the physical directory path for datapump export and import.

假定您具有创建目录所需的特权

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>

有关详情，请参见此处.

这篇关于参数“目录"的值无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！