I feel u should take use of small utility which u can prepare by urself. this utility can used to compare with both database. take one by one record from one database and see if its there or not in another database. if not dump that into some text.
It will be automatic utility, so the time u need is to create that. Utility will take few minutes to finish its task. I hope u understand what i mean to say. --- danny staple <[EMAIL PROTECTED]> wrote: > 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! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html 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/
