同事要做数据迁移测试,需要服务器权限,就在操作系统上给他创建了一个用户wzs,给分了dba组,拥有dba组的用户就可以正常操作数据库,而且可以使用最高权限(SYS)。
[root@SL010A-IVDB08 ~]# id wzs
uid=54322(wzs) gid=54322(dba) groups=54322(dba)
可是他在用impdp向这个数据库中导入数据的时候,遇到了下面的错误。
[wzs@SL010A-UVDB08 ~]$ impdp mig directory=BK dumpfile=ugcall.dmp logfile=impdp_ugcall.log
Import: Release 11.2.0.4.0 - Production on wed Mar 28 12:21:42 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 -64bit Production
With the Partitioning,OLAP,Data Mining and Real Application Testing options
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-2