执行impdp时遇到 ORA-06512,郁闷了半天后来发现在create directory的时候路径中有空格的缘故。
Import: Release 11.2.0.3.0 - Production on Thu Nov 10 19:26:25 2011
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.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-29283: invalid file operation
确认对DPUMPDIR 有rwx的权限。
仔细检查后发现在创建DPUMPDIR时路径有空格,去掉空格后重建问题解决。
create or replace directory DPUMPDIR as ' /home/oracle/oradmp' ;
SQL> select * from dba_directories WHERE DIRECTORY_name='DPUMPDIR';
OWNER DIRECTORY_NAME DIRECTORY_PATH
------------- -------------------------------------------------
SYS DPUMPDIR /home/oracle/oradmp
create or replace directory DPUMPDIR as ' /home/oracle/oradmp' ;
grant read ,write on directory DPUMPDIR to PROD_ADB;