ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings

Question

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?

score 16 · Accepted Answer · answered Jan 18 '13 at 11:15

16

more than likely, you granted:

grant import full database to YOURUSER;

instead grant:

grant imp_full_database to YOURUSER;

answered Jan 18 '13 at 11:15

DazzaL

1

YOURUSER here refers to the USER of a schema which you are trying to import from, am I correct ? – Paresh Aug 25 '16 at 13:31

score 1 · Answer 2 · answered May 22 '13 at 07:13

1

grant imp_full_database to YOURUSER;

will solve the issue , you will need to do it from a privileged DBA account or else you will get the below error

ORA-01919: role 'IMP_FULL_DATABASE' does not exist

answered May 22 '13 at 07:13

abhi

score 0 · Answer 3 · edited Jul 14 '15 at 07:04

0

You could use the following code:

grant datapump_imp_full_database to USER;

edited Jul 14 '15 at 07:04

skuntsel

answered Jul 14 '15 at 06:42

Saurabh Tandon

score 0 · Answer 4 · answered Mar 14 '22 at 09:53

0

For me answers above didn't work. Only way that helped - add admin option

grant imp_full_database to YOURUSER with admin option;

answered Mar 14 '22 at 09:53

Magomed Alibekov

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Mar 14 '22 at 13:15

4 Answers4