Did you have a question? Do you not understand why a primary key constraint would fail validation? Do you want to know how to diagnose the problem? Your post is more likely to get a response if you show that you have tried on your own to solve your problem, and then ask a specific question rather than just announcing that you have a problem. Paul Baumgartel CREDIT SUISSE Information Technology DBA & Admin - NY, KIGA 1 One Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sanjay Mishra Sent: Tuesday, March 06, 2007 2:50 PM To: oracle-l@xxxxxxxxxxxxx Subject: Urgent-ORA0001 Unique COnstraint Hi I had to load some big data into the table and it has a composite Primary Key. I had disabled the Primary Key and when trying to insert the data, it is still failing with the Constraint violation Thanks _____ Don't get soaked. Take a quick <http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news> peek at the forecast with theYahoo! <http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news> Search weather shortcut. ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ==============================================================================