database 如何从oracle数据库导出用户。（Oracle 10g 快捷版）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11221353/
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 users from oracle database. (Oracle 10g express edition)
提问by RAN
I am trying to export the user from database, but its showing
我试图从数据库中导出用户，但它显示
But if i am trying to export entire database then its successfully completing. I want to export only one user. How to fix the problem with this Oracle character set.
但是如果我试图导出整个数据库，那么它会成功完成。我只想导出一个用户。如何解决此 Oracle 字符集的问题。
Thanking you!
感谢您！
回答by Rene
To export just 1 user you can type the following:
要仅导出 1 个用户，您可以键入以下内容：
exp system/<system_password>@<database> file=<user>.dmp owner=<user>
The export utility will ask no further questions.
导出实用程序不会再问任何问题。
回答by Vivek
The previous one didn't work for me but the below worked for me. Kindly check
前一个对我不起作用，但下面的对我有用。好心检查
exp system/<system_password> file=<export_filename>.dmp owner=<schema_user_name>
Example
例子
exp system/oracle file=test_database.dmp owner=test_database
Cheers!!
干杯！！
