oracle IMPDP remap_schema 多个文件
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/34268997/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
IMPDP remap_schema multiple files
提问by A_V
Here is the correct syntax for a single schema IMPDP rename :
以下是单个模式 IMPDP 重命名的正确语法：
impdp system/**** directory=DATA_PUMP_DIR dumpfile=export_something.dmp logfile=imp.log remap_schema=name:newname
impdp system/**** directory=DATA_PUMP_DIR dumpfile=export_something.dmp logfile=imp.log remap_schema=name:newname
How would you import multiple schemas from one export while remapping them ? Will this work?
在重新映射它们时，您将如何从一个导出导入多个模式？这会起作用吗？
impdp system/**** directory=DATA_PUMP_DIR dumpfile=export_something.dmp logfile=imp.log remap_schema=name:newname,name2:newname2,name3:banana
impdp system/**** directory=DATA_PUMP_DIR dumpfile=export_something.dmp logfile=imp.log remap_schema=name:newname,name2:newname2,name3:banana
回答by A_V
I just tried IMPDP REMAP_SCHEMA on a live oracle instance and it works with the above syntax.
我刚刚在实时 oracle 实例上尝试了 IMPDP REMAP_SCHEMA，它使用上述语法。
You must only keep in mind these things :
你只需要记住以下几点：
-You can't remap the same schema under different names at once (For that impdp it multiple times)
- 您不能一次以不同的名称重新映射相同的架构（对于那个 impdp 多次）
-The schema names have to be in your export (of course)
- 模式名称必须在您的导出中（当然）
