oracle数据泵导出更换字符集,Oracle 11g 用数据泵 expdp/impdp 迁移数据时字符集不同的解决方法...

导出：

[oracle@ora11g ~]$ expdp study/study tables=t_stu dumpfile=expdp_stu.dmp directory=data_dir

Export: Release 11.2.0.4.0 - Production on Tue Apr 9 10:04:47 2019

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

Starting "STUDY"."SYS_EXPORT_TABLE_01":  study/******** tables=t_stu dumpfile=expdp_stu.dmp directory=data_dir

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/TRIGGER

. . exported "STUDY"."T_STU"                             15.47 KB     398 rows

Master table "STUDY"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for STUDY.SYS_EXPORT_TABLE_01 is:

/rmanbak/expdpdir/expdp_stu.dmp

Job "STUDY"."SYS_EXPORT_TABLE_01" successfully completed at Tue Apr 9 10:04:54 2019 elapsed 0 00:00:06

导入：

[oracle@oracle11g data_dir]$ impdp study/study directory=data_dir dumpfile=expdp_stu.dmp

Import: Release 11.2.0.4.0 - Production on Tue Apr 9 11:22:33 2019

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

Master table "STUDY"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "STUDY"."SYS_IMPORT_FULL_01":  study/******** directory=data_dir dumpfile=expdp_stu.dmp

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "STUDY"."T_STU"                             15.47 KB     398 rows

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/TRIGGER

Job "STUDY"."SYS_IMPORT_FULL_01" successfully completed at Tue Apr 9 11:22:38 2019 elapsed 0 00:00:03