Maybe you could generate a checksum for the soundex of the alpha columns - strip off the first letter (an alpha character), sum those and compare them. It sounds a little torturous - but I think that would be possible - and would probably give you a fairly good indication of the integrity.
Danny --=- On 4/29/05, Abinanthan.B <[EMAIL PROTECTED]> wrote: > Guyz it will take too much of time to fetch the data from oracle into text > or any other format. > And i got very little time. > > To be clear i have decided not to compare in the above said method. But i am > trying to verify by the counts and sums. > For example one scenario wud be to count the records in both version. > Another will be summing up all the values in one particular column(which > contains only numbers) and verifying it. > > Can u tell me how to apply the same strategy if the field has alpha numeric > where SUM option is not suitable, and also i wud be thankful if u suggest me > more scenario like this.. > > Regards > Abinanthan B > > > -----Original Message----- > From: [email protected] > To: [email protected] > Sent: 28/04/2005 19:39 > Subject: Re: [tech4all] How to compare millions of records in a table in > oracle 8i agains t 9i? > > On 4/28/05, Abinanthan.B <[EMAIL PROTECTED]> wrote: > > As one of project requirements we have to test the data migration. > That is a > > set of data is migrated from oracle8i to oracle9i. How can we compare > them? > > note that the count of records can be in millions. > > One simple way is to dump the data to a text file from each and do a > text diff on the text file. Is the data supposed to be identical, or > is there some translation involved? > > _____ > > Yahoo! Groups Links > > * To visit your group on the web, go to: > http://groups.yahoo.com/group/tech4all/ > <http://groups.yahoo.com/group/tech4all/> > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > ****** This email is confidential and is intended for the original > recipient(s) only. If you have erroneously received this mail, please delete > it immediately and notify the sender. Unauthorized copying, disclosure or > distribution of the material in this mail is prohibited. Views expressed in > this mail are those of the individual sender and do not bind Thinksoft > Global Services (P) Ltd. or its subsidiary, unless the sender has done so > expressly with due authority of Thinksoft.****** > > Yahoo! Groups Links > > > > > -- http://orionrobots.co.uk - Build Robots Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/tech4all/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
