ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings

Bishan picture Bishan · Jan 18, 2013 · Viewed 24.5k times · Source

When I'm trying to run impdp command in sqlplus, I got below error.

ORA-31631: privileges are required

ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings.

I have granted IMPORT FULL DATABASE privileged to schema which I'm trying to import. but I'm getting above error.

How could I solve this?

Answer

DazzaL picture DazzaL · Jan 18, 2013

more than likely, you granted:

grant import full database to YOURUSER;

instead grant:

grant imp_full_database to YOURUSER;