RE: Quick and dirty way to compare table contents

 The new DBA version of toad says ... compare contents as well as ...compare rows. .  

Brian
-----Original Message-----
From: LiShan Cheng [mailto:exriscer_at_gmail.com] Sent: Monday, February 27, 2006 6:55 AM
To: Spears, Brian
Cc: ranko.mosic_at_gmail.com; stephenbooth.uk_at_gmail.com; _oracle_L_list Subject: Re: Quick and dirty way to compare table contents  

AFAIK Toad counts number of rows to compare, does not compare the table contents.

On 2/27/06, Spears, Brian < BSpears_at_limitedbrands.com <mailto:BSpears_at_limitedbrands.com> > wrote: I use toad 8 dba.. Compares table contents. Life saver man on messy installs  

Brian
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> ] On Behalf Of Ranko Mosic Sent: Saturday, February 25, 2006 7:03 PM To: stephenbooth.uk_at_gmail.com
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_at_gmail.com <mailto:stephenbooth.uk_at_gmail.com> > wrote: On 22/02/06, Bobak, Mark < Mark.Bobak_at_il.proquest.com <mailto:Mark.Bobak_at_il.proquest.com> > 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    

--
http://www.freelists.org/webpage/oracle-l