Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why am I still getting ORA-31631 and ORA-39149 when invoking impdp?

2701424Jun 25 2014 — edited Jun 25 2014

I want to copy all materials in the user webportal production database to a developer/testing database set up on another machine called dev_webportal

My source database is: webportal

My target database is: dev_webportal

Directory is: my log

NETWORK_LINK is: to webportal

I have used the following command: impdp dev_webportal/xxxx DIRECTORY=dmpdir NETWORK_LINK=old_webportal schemas=webportal remap_schema=webportal:dev_webportal

I then receive the following error:

ORA-31631: privileges are required

ORA-39149: cannot link privileged user to non-privileged user

I added IMP_FULL_DATABASE and EXP_FULL_DATABASE rights both to webportal and dev_webportal. What is going on here? This is weird and I am completely stuck.

Thanks,
Heath

This post has been answered by 2701424 on Jun 25 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2014

Added on Jun 25 2014

#database-key-features, #export-import-sql-loader-external-tables, #import, #schema

1 comment

2,455 views