oracle-databaseoracle-dump

Does Expdp utility requires EXP_FULL_DATABASE privilege while exporting the same schema over network link

I am using expdp utility over a 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

ORA-31631: privileges are required ORA-39149: cannot link privileged user to non-privileged user

So do we need EXP_FULL_DATABASE privilege for exporting the same schema?

Solution

  • Both the local and remote users require the EXP_FULL_DATABASE role granted to them while using NETWORK_LINK switch in data pump.

    Check the following confirming the same: http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php