Oracle 11g在同一台Linux服务器从实例1全库导入到实(2)

导出实例上：

[oracle@pttest4 expdpimpdp]$ export ORACLE_SID=pt1; [oracle@pttest4 expdpimpdp]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri May 29 21:32:50 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name from v$database; NAME --------- pt1 SQL> SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET'); PARAMETER VALUE ---------------------------------------------------------------- ---------------------------------------------------------------- NLS_CHARACTERSET ZHS16GBK NLS_NCHAR_CHARACTERSET AL16UTF16 SQL>

此时，两个实例上字符集一模一样了，保持一致。

7，重新导入impdp [oracle@pttest4 admin]$ export ORACLE_SID=pt2; [oracle@pttest4 admin]$ impdp \'sys/sysdevpd@pt2 as sysdba\' directory=dir_dump_t3 dumpfile=expdpfull_pd_20150529_02.dmp nologfile=y TABLE_EXISTS_ACTION=REPLACE

OK，一切正常，可以导入到实例2上面了。