0

While trying to remap schema in impdp i am getting this error. ORA-31631: privileges are required ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings. Priviledges are granted to users inside sql shell. I am executing as oracle user how to grant priviledge to it.I am executing impdp after doing su - oracle

Abhishek Kumar
  • 1
  • 1
  • 1
  • What is the question? – Troy Nov 16 '16 at 04:35
  • Check this : [http://stackoverflow.com/questions/14397668/ora-39122-unprivileged-users-may-not-perform-remap-schema-remappings](http://stackoverflow.com/questions/14397668/ora-39122-unprivileged-users-may-not-perform-remap-schema-remappings) – Ranjana Ghimire Nov 16 '16 at 05:13

1 Answers1

0

Grant imp_full_database role to the database user and then import

Sandeep kazipeta
  • 1