Depending on the size of the table I would export the table from
Prod and import the table to test and do a left outer join where all the
column of the B table are null.
I am assuming A table as the test table and B table as the
production table.

e.g.
select a.* from a,b where a.id=b.id(+) and b.id is null

Deepak



-----Original Message-----
From: Marge Lewek [mailto:[Email Address Removed] Monday, September 30, 2002 12: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