Comparing two Oracle schema, other users

Posted by Igman on Stack Overflow See other posts from Stack Overflow or by Igman
Published on 2010-06-10T00:20:17Z Indexed on 2010/06/10 0:22 UTC
Read the original article Hit count: 625

Hello! I have been tasked with comparing two oracle schema with a large number of tables to find the structural differences in the schema. Up until know I have used the DB Diff tool in Oracle SQL Developer, and it has worked very well. The issue is that now I need to compare tables in a user that I cannot log into , but I can see it through the other users section in SQL developer. The issue is that whenever I try to use the diff tool to compare those objects to the other schema it does not work. Does anyone have any idea how to do this? It would save me a very large amount of work. I have some basic SQL knowledge if that is whats needed. Thanks.

© Stack Overflow or respective owner

Related posts about database

Related posts about Oracle