in reply to need to look for data differences in same table in two database instances
Let your DBA load one of those table to the other database, then use minus operator (Oracle supports it) to compare.
This one gives you those rows exists in 1 but not 2:
select * from table1 minus select * from table2
This one gives you those rows exists in 2 but not 1:
select * from table2 minus select * from table1
|
|---|