oracle11gdatapumpimpdp

ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings

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?

Solution

  • more than likely, you granted:

    grant import full database to YOURUSER;

    instead grant:

    grant imp_full_database to YOURUSER;