Oracle Database Discussions

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!

How to import a schema from full expdp file?

epipkoDec 12 2023

Oracle 11.2.0.4

I am trying to “refresh” data in test from production. I took a full export of prod and moved the dump file to the test server. I need to be able to import one of the schemas only. When I try to import it, I get lots of ORA-31684 and ORA-39151 errors.

Do I need to drop that schema in test first?

Import command will be:

impdp system/wm DIRECTORY=dp_dir DUMPFILE=wm_expdp.dmp SCHEMAS=WM

This post has been answered by epipko on Dec 13 2023

Jump to Answer

Added on Dec 12 2023

#impdp

3 comments

2,320 views

1 mention