RE: Urgent-ORA0001 Unique COnstraint

From: <jim.silverman_at_thomson.com>
Date: Tue, 6 Mar 2007 15:53:36 -0500
Message-ID: <E2157B37A63D2E4B9B00575021FC84D6835831@tshusmian2msg01.ERF.THOMSON.COM>

Sanjay, is it possible there is another unique index (i.e., other than the one that enforces the primary key constraint) on this table?

Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone: 734-669-7641

FAX:            734-930-7611 
E-Mail:         jim.silverman_at_thomson.com 
		
		From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra
		Sent: Tuesday, March 06, 2007 3:46 PM
		To: Baumgartel, Paul; oracle-l_at_freelists.org
		Subject: RE: Urgent-ORA0001 Unique COnstraint
		
		Paul
		 
		I had a question that if I was told by one user that

they are loading some data into the DW table and disable the constraint but still getting the error about the unique Constraint.

I tried to insert data into the Primary Key column and found that it is failing with Unique Constraint Error even the constraint is disabled.

I tried to drop the constraint and tried to insert the data and found the same Unique constraint error which gives and idea the Primary Key related index is still not dropped even I dropped the Primary key constraint. I don't know if this is possible that If I drop the constraint using alter table drop constraint command and it is still not dropping the index.

I hope this make more sense.

Sanjay

"Baumgartel, Paul" <paul.baumgartel_at_credit-suisse.com> wrote:

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_at_credit-suisse.com 
		www.credit-suisse.com 
		 
		
		
		From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra
		Sent: Tuesday, March 06, 2007 2:50 PM
		To: oracle-l_at_freelists.org
		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 peek at the forecast
<http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&>

with theYahoo! Search weather shortcut.
<http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&>

Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

		TV dinner still cooling?
		Check out "Tonight's Picks"

<http://us.rd.yahoo.com/evt=49979/*http://tv.yahoo.com/> on Yahoo! TV.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 06 2007 - 14:53:36 CST