生产环境中经常使用到Oracle的IMP导入和EXP导出来功能来达到数据迁移的目的,通常在源数据库和目标数据库中查询字符集是否致,
测试环境中导入IMP导入报错信息如下:
导入命令如下:
[oracle@localhost.localdomain:/soft]$imp scott/scott file=/soft/scott_v1.dmp log=/soft/scott_v1.log ignore=y full=y
Import: Release 11.2.0.4.0 – Production on Sun Oct 22 16:26:27 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.02.00 via conventional path
import done inZHS16GBK character set andAL16UTF16 NCHAR character set –提示字符集不一致
. importing SCOTT’s objects into SCOTT
. . importing table “BONUS” 0 rows imported
. . importing table