When i used 'REMAP_SCHEMA=source_schema:target_schema' systax to transfer the data from specified schemas,
the process came out as below(partly):
F:\script>impdp system/system, remap_schema=mz003:test, logfile=20130715.log
Import: Release 11.2.0.1.0 - Production on 星期一 7月 15 11:22:03 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39146: 方案 "MZ003" 不存在 (it reminded me the source_schema didn't exist, this confused me)
已成功加载/卸载了主表 "SYSTEM"."SYS_IMPORT_FULL_01"
启动 "SYSTEM"."SYS_IMPORT_FULL_01": system/********, remap_schema=mz003:test, logfile=20130715.log
处理对象类型 SCHEMA_EXPORT/USER
处理对象类型 SCHEMA_EXPORT/SYSTEM_GRANT
处理对象类型 SCHEMA_EXPORT/ROLE_GRANT
处理对象类型 SCHEMA_EXPORT/DEFAULT_ROLE
处理对象类型 SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
处理对象类型 SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-31684: 对象类型 SEQUENCE:"MZ001"."SEQ_TESTMERGE_ID" 已存在
ORA-31684: 对象类型 SEQUENCE:"MZ001"."SEQ_T_RETURN_KY_DAY" 已存在
ORA-31684: 对象类型 SEQUENCE:"MZ001"."SEQ_MATERIA_APPLY_DAY" 已存在
ORA-31684: 对象类型 SEQUENCE:"MZ001"."SEQ_T_STOCK_BRANCH_DAY_ID" 已存在
。。。
plz notice that my target_schema had become from ‘test’ to ‘MZ001’
database version is 11.2.0.1.0