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