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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

To find Missing DB Objects from one schema,sid to other schema,sid

user11384749Dec 27 2011 — edited Dec 28 2011

Hi Friends..

I have an requirement as bellow...

Recently we migrated from one schema to other ,some of the DB objects are missed while migrating.
After Migration now the schema and SID are Different for newly created schema

while comparing the newly created schema2 with old schema1 found that some of the DB objects are missed.
So i need to find out the difference's from Schema1 to Schema2.
But now schema 2 is having different sid and schema name and to make the changes in schema2 with respect to schema1.

Please let me know how to go ahead with this....

Thanks in advance...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 25 2012

Added on Dec 27 2011

6 comments

1,107 views