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.
Best Answer
Comparing dmp files like that is probably quite difficult to do, as the format is quite complex, with snippets of embedded SQL and all sorts. Having said that, although it is a binary format, it is a stream format (i.e. no internal pointers), so it's quite amenable to processing with sed.
I think loading the contents of he dmp files into two schemas and comparing the two is by far the easiest way you're going to do this, barring the existence of some tool that I'm not aware of.