ORA-39002/ORA-29070/ORA-29283/ORA-06512/ORA-29283错误
来源:互联网 发布:网络面板插口接法 图解 编辑:程序博客网 时间:2024/05/22 03:35
1、问题描述
mkdir d:/oradata
sqlplu / as sysdba
create directory datadump as 'd:\oradata';
grant read,write on directory datadump to system;
把备份文件拷贝到D盘下的oradata目录里面,执行下面命令:
C:\Documents and Settings\Administrator>impdp system/password directory=datadump dumpfile=zhongse_zh_2014102015pm.dmp logfile=zhongse_zh_2014102015pm_imp.log remap_schema=zhongse_zh:zhongse_zh table_exists_action=replace
Export: Release 10.2.0.1.0 - Production on 星期四, 30 7月, 2009 16:37:12
Copyright (c) 2003, 2005, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: 操作无效
ORA-39070: 无法打开日志文件。
ORA-29283: 文件操作无效
ORA-06512: 在 "SYS.UTL_FILE", line 475
ORA-29283: 文件操作无效
2、问题
在创建目录的时候,路径写错了("D:\oradata"),应该是写成”D:/oradata“。
这个容易跟Linux的目录路径发生混淆”/home/oracle/datadump"。
3、解决方法:
sqlplus / as sysdba
drop directory datadump;
create directory datadump as 'd:/oradata';
grant read,write on directory to system;
exit
然后再倒入,问题解决。
0 0
- ORA-39002/ORA-29070/ORA-29283/ORA-06512/ORA-29283错误
- ORA-39002 ORA-39070 ORA-29283 ORA-06512 ORA-29283
- ORA-39002、ORA-39070、ORA-29283、ORA-06512
- ORA-39002,ORA-39070,ORA-29283, ORA-06512,ORA-29283解决办法
- ORA
- ora
- 【ORA错误】ORA-12528
- ORACLE11G RAC expdp报错ORA-39002 ORA-39070 ORA-29283 ORA-06512
- ORA-00936 ORA-06512
- ora-29280,ora-06512
- ora-39002 ora-31694 ora-02354 ora-02368 ora-02369
- ORA-07445 ORA-24324 ORA-01041错误
- IMPDP 导入时报ORA-39014 ORA-39029 ORA-31671 ORA-04030 ORA-06512错误
- oracle数据库:ORA-04091、ORA-06512、ORA-04088错误分析
- ora-00341 ora-00312错误
- ora-01034 / ORA-27101 错误.
- ORA-01034&ORA-27101错误
- ORA-01034&ORA-27101错误
- HDU-#4463 Outlets(次小生成树)
- 一起创业
- TCP和UDP服务器的设计
- 目录的简单操作
- datatable导出到excel NPOI组件
- ORA-39002/ORA-29070/ORA-29283/ORA-06512/ORA-29283错误
- [linux中断]——中断处理
- 路径去重
- WebService从零开始
- 科来回溯分析系统精准定位“匿名者”DDOS攻击
- Opencv+vs2010安装配置
- 常用正则表达式
- 读写plist文件
- springmvc 配置