Geek Answers Handbook

Expdp utility requires EXP_FULL_DATABASE privilege when exporting the same schema via a network link

I am using the expdp utility on a network link. I need to export only one schema that I own. Ideally, this should allow me to export the schema that I own. But I get an error like

ORA-31631: Privileges required ORA-39149: Cannot associate privileged user with non-privileged user

So, do we need the EXP_FULL_DATABASE privilege to export the same schema?

+4
source share
2 answers

EXP_FULL_DATABASE, NETWORK_LINK .

: http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php

+1

, , :

USERID, , DATAPUMP_IMP_FULL_DATABASE , DATAPUMP_EXP_FULL_DATABASE . ( http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm)

, DATAPUMP_IMP_FULL_DATABASE , DATAPUMP_EXP_FULL_DATABASE .

+2

More articles:


All Articles