Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REMAP_SCHEMA went to the wrong target_schema

g29tonyJul 14 2013 — edited Jul 15 2013

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’ toMZ001’

database version is 11.2.0.1.0

This post has been answered by DK2010 on Jul 15 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2013
Added on Jul 14 2013
6 comments
1,095 views