本文记录了一次使用Oracle数据库导出数据时遇到的问题及其解决过程。主要错误包括ORA-39002:无效操作，ORA-39070:无法打开日志文件等。通过创建或替换目录解决了这个问题。
[oracle@orcl admin]$ expdp system/123d@orcl directory=dpdata1 dumpfile=dove20160814.dmp SCHEMAS=dove
Export: Release 11.2.0.1.0 - Production on Tue Aug 16 18:51:44 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.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
Export: Release 11.2.0.1.0 - Production on Tue Aug 16 18:51:44 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.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
解决办法：
SQL> create or replace directory dpdata1 as '/u01/app/oracle/backup';
Directory created.
扫一扫
5745
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
