Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Quick and dirty way to compare table contents

Re: Quick and dirty way to compare table contents

From: bill thater <shrekdba_at_gmail.com>
Date: Wed, 22 Feb 2006 15:26:28 -0600
Message-ID: <a1d204910602221326q55187aecpda77e67c2587fbfd@mail.gmail.com>


On 2/22/06, Maxim <mdemenko_at_gmail.com> wrote:
>
>
> Don't think it will work ( possible different nls settings, statistics come
> in mind), but even simply exported the same schema twice ( into different
> files) and got different checksums for both files.

i seem to remember that there are several tools [toad comes to mind, not sure about tora] that do a comparison between 2 schemas in 2 diffferent databases. would that work for you?

--
--
Bill "Shrek" Thater     ORACLE DBA
       shrekdba_at_gmail.com
------------------------------------------------------------------------
"While preceding your entrance with a grenade is a good tactic in
Quake, it can lead to problems if attempted at work." -- C Hacking
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 22 2006 - 15:26:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US