Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent-ORA0001 Unique COnstraint

Re: Urgent-ORA0001 Unique COnstraint

From: sol beach <sol.beach_at_gmail.com>
Date: Tue, 6 Mar 2007 14:41:33 -0800
Message-ID: <40a16b360703061441x2f39c813jf7a6867e688eae51@mail.gmail.com>


I have not tested this recently, but I believe it was true at 1 point in time on some version of Oracle.

If the PK index is created at the same time as th PK constraint, then the index will be dropped when the constraint is disabled. However, if the UNIQUE index is created first & then the PK is created, when the constraint is disabled the UNIQUE index remains intact.

HTH & YMMV! On 3/6/07, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
>
> 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&#news>
> with theYahoo! Search weather shortcut.<http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news>
>
> ============================================================================== 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 - 16:41:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US