连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> create directory dump_dir as 'c:\dump';目录已创建。SQL> grant read,write on directory dump_dir to system;授权成功。SQL>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*===============================================================
C:\>expdp system/surdb directory=dump_dir dumpfile=mytable.dmp tables=scott.empExport: Release 11.1.0.6.0 - Production on 星期五, 29 10月, 2010 10:14:46Copyright (c) 2003, 2007, Oracle. All rights reserved.连接到: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: 操作无效
ORA-39070: 无法打开日志文件。
ORA-29283: 文件操作无效
ORA-06512: 在 "SYS.UTL_FILE", line 488
ORA-29283: 文件操作无效
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
请高手指教,为什么出现这样的问题
--直接这样
create or replace directory dum_dir as 'C:\'
不行啊,还是报错
ORA-39002: 操作无效
ORA-39070: 无法打开日志文件。
ORA-29283: 文件操作无效
ORA-06512: 在 "SYS.UTL_FILE", line 488
ORA-29283: 文件操作无效
这错误就是没找到实际目录没找到
sys创建目录 授权给用户
> host mkdir c:\dump> create directory data_dump as 'c:\dump';
> grant read,write on directory data_dump to system;> host expdp system/surdb directory=data_dump dumpfile=mytable.dmp tables=scott.emp logfile=exp.log