CODEWITHSUNDEEP
oracle-databaseoracle-dump
Lone Developer
Lone Developer

Reputation: 616

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?

Upvotes: 4

Views: 19192

Answers (2)

pahariayogi
pahariayogi

Reputation: 1163

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

Upvotes: 1

dbra
dbra

Reputation: 631

Yes and no, depends on privilege you gave to target schema:

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)

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.

Upvotes: 3

Related Questions