如何使用 Oracle 的 impdp 附加数据？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1754472/
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
How do I append data with Oracle's impdp?
提问by Aaron Digulla
Does impdpalways truncate the table before it loads the data even if I don't recreate the meta data? If it does, is there an option to tell it to append the data instead?
impdp即使我不重新创建元数据，是否总是在加载数据之前截断表？如果是这样，是否可以选择告诉它附加数据？
回答by Dave Webb
What impdpdoes for existing tables is controlled by the TABLE_EXISTS_ACTIONparameter.
什么impdp确实为现有的表是由控制TABLE_EXISTS_ACTION参数。
impdp hr/hr TABLES=employees DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp TABLE_EXISTS_ACTION=APPEND
However, if you're already using CONTENT=DATA_ONLYwhich it sounds like you are TABLE_EXISTS_ACTIONshould be defaulting to APPENDso I'm not sure why you're seeing the behaviour you describe.
但是，如果您已经在使用CONTENT=DATA_ONLY它，那么您TABLE_EXISTS_ACTION应该默认使用它，APPEND所以我不确定您为什么会看到您所描述的行为。
