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 <*> 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/
