oracle remap schema,impdp的remap_schema选项的另一个schema是否要重建

刚才和同学聊天,说到数据泵IMPDP的remap_schema会不会自动创建用户.做了一个实验.

remap_schema后面的用户需要建立好,才行.

[oracle@rh5 ~]$ impdp system/oracle directory=mydir dumpfile=exp_dp.dmp remap_schema=hr:lkn

Import: Release 11.2.0.3.0 - Production on Fri Apr 3 21:34:36 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

UDI-12162: operation generated ORACLE error 12162

ORA-12162: TNS:net service name is incorrectly specified

[oracle@rh5 ~]$ p1

[oracle@rh5 ~]$ impdp system/oracle directory=mydir dumpfile=exp_dp.dmp remap_schema=hr:lkn

Import: Release 11.2.0.3.0 - Production on Fri Apr 3 21:35:00 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Applicatio