Re: Quick and dirty way to compare table contents
- From: "LiShan Cheng" <exriscer@xxxxxxxxx>
- To: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
- Date: Mon, 27 Feb 2006 13:43:27 +0100
I think you mean the Compare Data Wizard?
On 2/27/06, Spears, Brian <BSpears@xxxxxxxxxxxxxxxxx > wrote:
>
> The new DBA version of toad says ... compare contents as well as
> …compare rows. .
>
>
>
> Brian * *
>
> -----Original Message-----
> *From:* LiShan Cheng [mailto:exriscer@xxxxxxxxx]
> *Sent**:* Monday, February 27, 2006 6:55 AM
> *To:* Spears, Brian
> *Cc:* ranko.mosic@xxxxxxxxx; stephenbooth.uk@xxxxxxxxx; _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@xxxxxxxxxxxxxxxxx> wrote:
>
> 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:
