RE: Quick and dirty way to compare table contents

  • From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
  • To: <ranko.mosic@xxxxxxxxx>, <stephenbooth.uk@xxxxxxxxx>
  • Date: Mon, 27 Feb 2006 06:45:14 -0500

I use toad 8 dba.. Compares table contents. Life saver man on messy installs
 
Brian 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Ranko Mosic
Sent: Saturday, February 25, 2006 7:03 PM
To: stephenbooth.uk@xxxxxxxxx
Cc: _oracle_L_list
Subject: Re: Quick and dirty way to compare table contents
 
Again, as far as I am concerned, we can "close" this one. We are using
simple num_rows count.


 
On 2/25/06, stephen booth <stephenbooth.uk@xxxxxxxxx> wrote: 
On 22/02/06, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote: 
>
> I think you need to have a conversation with your boss that goes something
> like this:
>
> "Hey boss, you can ask me to do something, or you can tell me how to do
> it....but you can't do both!"  ;-) 

I'm inclined to agree, although I know that sometimes it's just not
possible.

>
> Ok, here's an actual attempt to answer your question:
> Spool contents of table to a file, compute md5 sum.
> Spool contents of other table to file, compute md5 sum.
> Compare md5 sums.
>

Could do that, there's plenty of utils out there (many of them free
downloads) for calculating checksums.  If your boss wants something 
programatic looking you can always encapsulate the calls to SQL*Plus
to spool the files, the calls to the checksum generator and the check
 

Other related posts: