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: 651
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