oracle Expdp 实用程序在通过网络链接导出相同模式时是否需要 EXP_FULL_DATABASE 权限
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/19582006/
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
Does Expdp utility requires EXP_FULL_DATABASE privilege while exporting the same schema over network link
提问by somaniA
I am using expdp utility over network link . I need to export only one schema which i own . ideally it should allow me to export the schema which i own . But i am getting error like
我正在通过网络链接使用 expdp 实用程序。我只需要导出我拥有的一个架构。理想情况下，它应该允许我导出我拥有的架构。但我收到了类似的错误
ORA-31631: privileges are required ORA-39149: cannot link privileged user to non-privileged user
ORA-31631: 需要特权 ORA-39149: 无法将特权用户链接到非特权用户
So do we need EXP_FULL_DATABASE privilege for exporting the same schema ?
那么我们是否需要 EXP_FULL_DATABASE 权限来导出相同的模式？
采纳答案by pahariayogi
Both the local and remote users require the EXP_FULL_DATABASErole granted to them while using NETWORK_LINK switch in data pump.
在数据泵中使用 NETWORK_LINK 开关时，本地和远程用户都需要授予他们EXP_FULL_DATABASE角色。
Check the following confirming the same: http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php
检查以下确认相同：http: //www.oracle-base.com/articles/10g/oracle-data-pump-10g.php
回答by dbra
Yes and no, depends on privilege you gave to targetschema:
是和否，取决于您赋予目标架构的特权：
If the USERID that is executing the import job has the DATAPUMP_IMP_FULL_DATABASE role on the target database, then that user must also have the DATAPUMP_EXP_FULL_DATABASE role on the source database. (from http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm)
如果执行导入作业的 USERID 在目标数据库上具有 DATAPUMP_IMP_FULL_DATABASE 角色，则该用户在源数据库上也必须具有 DATAPUMP_EXP_FULL_DATABASE 角色。（来自http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm）
So you could either remove the DATAPUMP_IMP_FULL_DATABASE role from the target schema, or give the DATAPUMP_EXP_FULL_DATABASE role to source schema.
因此，您可以从目标模式中删除 DATAPUMP_IMP_FULL_DATABASE 角色，或者将 DATAPUMP_EXP_FULL_DATABASE 角色赋予源模式。
