Hi Abi, I am not that much familiar with Oracle...
You can use TOAD... In TOAD... Goto TOOLS menu.. and there u can find a option know as Compare Data.. There you have option to give source database and destination database... I haven't tried so far.. but there is option to do that... :-) If this works please let me know.. _aHaMeD________________ INFOSYS TECHNOLOGIES LTD Bangalore. Mobile : 9880906637 _______________________ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Abinanthan.B Sent: Thursday, April 28, 2005 7:15 PM To: '[email protected]' Subject: [tech4all] How to compare millions of records in a table in oracle8i against 9i? Hi all, 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. Thanx in advance Abinanthan B ****** 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 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/
