If you have toad use compare utility.

You can dump the data in text files and diff it. Jarred Still has scripts to do that.

Lastly querying over database links could be another solution.

-----Original Message-----
From: Marge Lewek [mailto:[Email Address Removed] Monday, September 30, 2002 3:58 PM
To: LazyDBA.com Discussion
Subject: comparing a table in prod to a table in test



What is the best way to compare the data in one instance to the data in another instance. I need to keep a test tables data in sync with the data that is in prod.....a trigger is not an option, since we do not want production to be dependent on a test table.

I tried an export on both and then the unix diff command, but it doesn't seem to work.

Any ideas would be appreciated.

Thanks in advance.

Oracle LazyDBA home page