database 如何在 oracle 11g 中仅导出和导入数据？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13415257/
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 to export & import only data in oracle 11g?
提问by Nitesh Kumar
I want to export only data on of my master tables and then imports it to some other server on same oracle 11g . Is it possible to do that. using exp command it dumps the complete data along with schema which I don`t want . I want only data to be dump and imported to some other location.
我只想导出我的主表上的数据，然后将其导入到同一 oracle 11g 上的其他服务器。有没有可能做到这一点。使用 exp 命令它会转储完整的数据以及我不想要的模式。我只想转储数据并导入到其他位置。
Please help me out.
请帮帮我。
Thanks,
谢谢，
Nitesh Kumar
尼特什·库马尔
回答by Alex Poole
You can't with the original export (exp) utility, but with the newer data pump expdpyou can use the contentparameterto export only the data:
您不能使用原始的 export ( exp) 实用程序，但使用较新的数据泵，expdp您可以使用该content参数仅导出数据：
expdp content=data_only ...
With expI think the closest equivalent is to set ignore=yon import; it will try to recreate the schema objects but won't complain that they're already there. But since the original utilities are deprecated, you should use data pump anyway.
随着exp我认为最接近的等效是集ignore=y进口; 它会尝试重新创建模式对象，但不会抱怨它们已经存在。但是由于不推荐使用原始实用程序，因此无论如何您都应该使用数据泵。
