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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Verifying data across 2 db

Re: Verifying data across 2 db

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 10 Apr 2003 17:45:52 -0700
Message-ID: <5fola.2500$%X5.1685@fed1read03>


PoohPooh wrote:
> I am doing a verification of the same set of data loaded to an Ingres
> DB and an Oracle DB. I wanted to do some kind of "checksum'. For
> numeric attributes (integer, float ...), it's easy. I can just do a
> summation of the numeric columns and compare the total across the 2
> db. However, I have trouble with checking string attributes (char,
> varchar ...). Summation won't work on string attributes. Is there any
> good suggestion?

The book "Perl for Oracle DBA's" shows how to do this. Received on Thu Apr 10 2003 - 19:45:52 CDT

Original text of this message

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