oracle数据泵impdp命令导入报错UDI-00013: Message 13 not found; No message file for product=RDBMS, facility=UDI
来源:互联网 发布:flv视频编辑软件 编辑:程序博客网 时间:2024/05/21 12:16
oracle数据泵impdp命令导入报错
C:\Users\Administrator>impdp xydc/xydc@orcl DIRECTORY=impdp_dir DUMPFILE=XYNC631
UDI-00013: Message 13 not found; No message file for product=RDBMS, facility=UDI
UDI-00019: You may need to set ORACLE_HOME to your Oracle software directory
如下图所示;
解决办法是,1.先设置ORACLE_HOME的环境变量
C:\Users\Administrator>set ORACLE_HOME=D:\Oracle\product\11.2.0\dbhome_1
2.用oracle的dba管理员登录C:\Users\Administrator>sqlplus / as sysdba
提示输入用户名时:sys
提示输入密码时:super (默认是这个密码,如果自己修改过,即用修改过的密码)
最后会提示登录错误,会重新返回C:\Users\Administrator>
如下图所示:
不用怕,此时再输入命令即可:impdp xydc/xydc@orcl DIRECTORY=impdp_dir DUMPFILE=XYNC631021.DMP logfile=XYNC_xydc_20141114_impdp.log
即可导入数据。
如果想指定导到某一用户,可以加remap_schema参数,例如:
impdp xydc/xydc@orcl DIRECTORY=impdp_dir DUMPFILE=XYNC631021.DMP logfile=XYNC_xydc_20141114_impdp.log remap_schema=xync63:xydc
- oracle数据泵impdp命令导入报错UDI-00013: Message 13 not found; No message file for product=RDBMS, facility=UDI
- Message 2100 not found; No message file for product=RDBMS, facility=UL
- Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No mes
- EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP问题的解决方案
- EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP问题的解决方案
- tnsping 报错Message 3511 not found; No message file for product=network, facility=TNSTNS-03505:
- TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS
- TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS
- Message 1070 not found; No message file for product=network, facility=TNSTNS-12546: Message 12546 no
- Message 1070 not found; No message file for product=network, facility=TNSTNSLSNR for Linux: Version
- TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS(转)
- ora-12528 : message 12528 not found; product=RDBMS ; facility=ora
- ORA-17627: ORA-12577: Message 12577 not found; product=RDBMS; facility=ORA
- ora-12528 : message 12528 not found; product=RDBMS ; facility=ora
- impdp一个诡异的报错UDI-31623 ORA-31623
- 计划任务里执行包含连接oracle命令的shell脚本报错:SP2-0667: Message file sp1<lang>.msb not found
- oracle安装, Message file sp1<lang>.msb not found
- rman备份报错Message file RMAN<lang>.msb not found
- hibernate映射
- 阿里CEO陆兆禧:注册双十一是为保护这个节日
- QuickXDev增强功能:Run With Player
- DotNetBar.Bar图标列表的使用
- Spinner 绑定 Arraylist .
- oracle数据泵impdp命令导入报错UDI-00013: Message 13 not found; No message file for product=RDBMS, facility=UDI
- JAVA MessageDigest(MD5加密等)
- java date类型和calendar类型区别
- 吐槽
- LinkedList,ArrayList末尾插入谁效率高?
- google地图网络服务API
- 读取一串整数,寻找合适的数据结构和算法,实现插入元素track(int x) 方法,以及GetRankOfNumber(int x)方法,返回值为小于等于x的元素个数(不包括x本身)
- CocoStudio UI编辑器自定义插件
- 专访冯晓海:从满座网到苏宁本地生活的蜕变之旅