Skip to Main Content

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!

expdp impdp full=y really works? sure it is but...

GeorgeZhouzhiqingAug 30 2018 — edited Aug 30 2018

I have done one expdp impdp for a 10.1 version database to another host with same directories in HPUX. however, after impdp, ignore all errors warning related to system and other default schemas, there is no errors reported related to user schemas, but the objects with invalid status in the targeted database are more than the source database, the application didn't work. I then had to use RMAN to just copy over the whole db.

The reason I ask is what I am thinking:

there are objects have dependency on other schemas, when the import happens, it loaded user1's object 1 which has dependancy on user2's object 2, but at this time, the user2's object2 doesn't exist yet, I assume it will be marked as invalid, how do the impdp fix this? do you have to reimport the user1's object1 again after the first impdp job done?

This post has been answered by EdStevens on Aug 30 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2018
Added on Aug 30 2018
4 comments
327 views