IMPDP ORA-06512

执行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;