I have the following situation: I have two identical schemas regarding the objects in those schemas. But the data in the tables differ.
I need to compare the two schemas and the export the difference as insert statements.
I am using Toad for Oracle Xpert edition, and I am unable to figure out how to do it. The schema compare feature does not include the data in the tables comparison, it only compares at object level. And the Data Compare feature can only compare for one table at a time. My schemas have hundreds of tables, I can’t do it manually one at a time, I need to do the whole compare in one go.
Is this possible?