SQL & PL/SQL

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 find missing object?

marlborocatJul 1 2021

Hi there,
I have two database, A and B. where A is the source and B is cloned using data pump. after the clone, I see some objects missing. How do I print out every missing object? I created a database link in B, pointing to A,
so basically compare dba_objects in database A, and dba_objects in database B.
the link exist in B, named sourcedblink

This post has been answered by Frank Kulash on Jul 1 2021

Jump to Answer

Added on Jul 1 2021

4 comments

1,295 views

1 mention