Thanks Fred, It was beacuse of H table which was still containg the records.
-- Regards, Bhupesh Gupta You say "deleting the records from target in the database". Do you mean you went in at the database and deleted all records from a table? If so did you delete all records from the related tables (T, H, and all related B tables)? Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Bhupesh Gupta Sent: Wednesday, May 20, 2009 2:17 AM To: [email protected] Subject: Index Error The value(s) for this entry violate a unique index that has been defined for this form I am facing this error while migrating data from source to target thru rrchive tool. I have already rebuild all indiexes after deleting the records from target in the database. Target DB is oracle and Source is SQL. PLease Suggest -- Regards, Bhupesh Gupta _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

