Hi,
I want to compare the row-count of 200 tables from one DB with another (which also contains the same 200 tables) to check whether the row count are in sync for these databases, I don't want to write 200 select count(*) from table statements , instead we should come up with a simplified SQL which should either compare these tables and provide the tables which are having discrepancies or is there any where we can compare at the DB level to find the tables which are having discrepancies, finally this operation shouldn't take much time even though some of these tables have huge amount of records. Hence, please let me know how we can create a simplified query to do this activity? is there any opensource tool to check this comparison as well? I am using SQL developer. Please clarify.
Thanks