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!

Refresh Schemas using Export/Import Data Pump (expdp & impdp)

TriBBAug 9 2014 — edited Aug 11 2014

Hi,

I am being asked to "Refresh" the TEST database (target) from the PRODUCTION database (source). The developers only need specific schemas to be refreshed (ALPHA, BETA, and GAMMA), but I perform a routine full export (expdp) of my production database. The suggestion from the developers is that I import (impdp) using full=y, but to exclude several schemas (e.g. SYS, SYSTEM, etc.). I am not 100% certain, therefore my start of this discussion, but I would think that using impdp ... schema=ALPHA, BETA, GAMMA ... without using FULL=Y would accomplish the same thing. What do you guys think?

Thanks in advance and I hope that we can call learn from this discussion/experience.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2014

Added on Aug 9 2014

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

5 comments

6,631 views