Re: Comparing contents of a table in 2 different database instances
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 28 Sep 2005 07:07:53 -0400
Message-ID: <4cSdnf615pIQ5KfeRVn-qw_at_comcast.com>
Date: Wed, 28 Sep 2005 07:07:53 -0400
Message-ID: <4cSdnf615pIQ5KfeRVn-qw_at_comcast.com>
"Naresh" <naresh_at_freesurf.ch> wrote in message
news:1127896134.593517.229210_at_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 Received on Wed Sep 28 2005 - 13:07:53 CEST