ORA-39122: unprivileged users cannot reassign REMAP_SCHEMA

Question

When I try to run the impdp command in sqlplus , I got the error below.

 ORA-31631: privileges are required ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings. 

I have provided IMPORT FULL DATABASE privileged schema I'm trying to import. but I get the above errors.

how can i solve this?

Answer 1

more than likely you provided:

 grant import full database to YOURUSER; 

instead of this:

 grant imp_full_database to YOURUSER; 

Answer 2

 grant imp_full_database to YOURUSER; 

will solve the problem, you will need to do this from a privileged DBA account, otherwise you will get the following error

 ORA-01919: role 'IMP_FULL_DATABASE' does not exist 

Answer 3

You can use the following code:

 grant datapump_imp_full_database to USER;