Ok calling an Oracle expert, DBA or general good guy
The problem is simple but trawling Mr Google has not come up with an easy to use solution.
I am testing data input.
I want to compare master.dmp with testers.dmp these have been created using exp in Oracle 11g the schema will be the same it is only the data input that will change.
The master.dmp was created when I put the data in myself using some sql and typing. Now I have to use the app and a tester(me) to see if the results are the same.
I can use ODBC and import data in Excel and uses Excel Compare Ok but it would be quicker to just compare the two .dmp files and highlight the changes .
Has any on done this? Has anyone a link to a tool or software that will compare two dmp files?
or is there a nice easy way to compare the data.