Comparing contents of a table in 2 different database instances

[Naresh]

Hello!

Could someone please tell me if there is way in TOAD or any other DB
management tool to check the contents (rows) of a table in 2 different
database instances? Thanks!

Naresh

[Mark C. Stock]

"Naresh" <naresh@freesurf.ch> wrote in message
news:1127896134.593517.229210@g43g2000cwa.googlegroups.com... Hello! Could someone please tell me if there is way in TOAD or any other DB management tool to check the contents (rows) of a table in 2 different database instances? Thanks! Naresh

in any tool: create a database link, then write a SELECT statement that that
accesses the local table and the remove table, using a join, minus,
intersect, or union depending on what type of data comparison you require

++ mcs

[Mark Bole]

Naresh wrote:
Hello! Could someone please tell me if there is way in TOAD or any other DB management tool to check the contents (rows) of a table in 2 different database instances? Thanks! Naresh

Try supplied package DBMS_RECTIFIER_DIFF (was developed specifically for
replication, but can be used outside of that context). See also
Metalink Note 1062732.6

-Mark Bole

[DA Morgan]

Mark Bole wrote: Naresh wrote: Hello! Could someone please tell me if there is way in TOAD or any other DB management tool to check the contents (rows) of a table in 2 different database instances? Thanks! Naresh Try supplied package DBMS_RECTIFIER_DIFF (was developed specifically for replication, but can be used outside of that context). See also Metalink Note 1062732.6 -Mark Bole

A demo of this built-in package can be found in Morgan's Library
at www.psoug.org.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)