RE: Urgent-ORA0001 Unique COnstraint

  • From: <jim.silverman@xxxxxxxxxxx>
  • To: <smishra_97@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Mar 2007 15:53:36 -0500

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@xxxxxxxxxxx 
                From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sanjay Mishra
                Sent: Tuesday, March 06, 2007 3:46 PM
                To: Baumgartel, Paul; oracle-l@xxxxxxxxxxxxx
                Subject: RE: Urgent-ORA0001 Unique COnstraint
                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.
                "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
                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 
                Phone 212.538.1143 
                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
                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
                Don't get soaked. Take a quick peek at the forecast
                with theYahoo! Search weather shortcut.
======  Please access the attached hyperlink for an important electronic
communications disclaimer:
                TV dinner still cooling?
                Check out "Tonight's Picks"
<*>  on Yahoo! TV.

Other related posts: