是否可以以非 dba 用户身份执行 oracle import util？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5241176/
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
Is it possible to do oracle import util as non-dba user?
提问by nayakam
When I try to import a oracle dump. Following error displayed,
当我尝试导入 oracle 转储时。显示以下错误，
Export file created by EXPORT:V10.02.01 via direct path
通过直接路径导出 EXPORT:V10.02.01 创建的文件
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00013：只有 DBA 才能导入其他 DBA 导出的文件
IMP-00000: Import terminated unsuccessfully
IMP-00000：导入终止失败
I just wondering, If the non-dba user export a dump file. Can non-dba user import the dump file ?
我只是想知道，如果非 dba 用户导出转储文件。非 dba 用户可以导入转储文件吗？
采纳答案by kupa
Yes , non-dba user can import/export files from his/her schema without any problem. But if it wants to import/export files to/from other schema it must have been granted IMP_FULL_DATABASE/EXP_FULL_DATABASE roles .
是的，非 dba 用户可以毫无问题地从他/她的模式导入/导出文件。但是如果它想从其他模式导入/导出文件，它必须被授予 IMP_FULL_DATABASE/EXP_FULL_DATABASE 角色。
BUT, here I can see that you are trying to import dump file, which was exported by direct path. In this situation just DBA can import directly exported file.
但是，在这里我可以看到您正在尝试导入通过直接路径导出的转储文件。在这种情况下，DBA 可以直接导入导出的文件。
You can temporarily grant DBA role to this user , import file and then revoke this privilege.
您可以临时授予此用户 DBA 角色，导入文件，然后撤销此权限。
SQL> conn / as sysdba
Connected.
SQL> grant IMP_FULL_DATABASE to test;
I hope it was helpfull for you :)
我希望它对你有帮助:)
回答by JOTN
Yes, it works fine to export and import under a non-DBA user. You'll still need a privileged login to create the destination user if it doesn't already exist.
是的，在非 DBA 用户下导出和导入工作正常。如果目标用户尚不存在，您仍需要特权登录才能创建目标用户。
