Oracle imp 和 exp 命令
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6610033/
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
Oracle imp and exp commands
提问by Vijay
Normally when i have to take a backup of of a database on unix, i do,
通常，当我必须在 unix 上备份数据库时，我会这样做，
exp DBUSER/DBPSW@INST file=xxx.dmp
or load from a dump
或从转储加载
imp DBUSER/DBPSW@INST file=xxx.dmp
my question here is :
我的问题是：
- how can we take a backup of a single table
- how can we import the data backup from the dump into a single table.
- how can we disable the constraints when taking a backup
- 我们如何备份单个表
- 我们如何将转储中的数据备份导入到单个表中。
- 我们如何在备份时禁用约束
I rarely do these when required.some times i need to do the above mentioned things but instead because i donot know i take the complete backup of all the table and load it. does anybody know how we can do it?
我很少在需要时做这些。有时我需要做上面提到的事情，而是因为我不知道我对所有表进行完整备份并加载它。有人知道我们怎么做吗？
