| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: unique constraint violation problem
Anna,
Who said we should not create unique indexes on tables? I do it all the time when I need uniqueness on a column other than the primary key. It happens very rarely, but it does happen.
I wish I were in the room when somebody makes a statement like this. It just shows their lack of experience in database design versus the real world.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, July 08, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Thanks for all of you who replied the message. I apologize for not explaining the problem clearer. Actually, the error was reported at 13:35:13pm from the application. There is a column called date_created in the table that records what time the record was created. The value of date_created for the record that caused error message is the same as reported from application. That's why I said that the record was inserted into the table successfully.
I know Oracle recommends that we do not explicitly define unique indexes on tables. Why?
Anna
>From: "Jacques Kilchoer" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: unique constraint violation problem
>Date: Mon, 07 Jul 2003 12:59:25 -0800
>
>My explanation would be that the record was NOT inserted successfully into
>the table. Proof of that would be that there are no duplicate records in
>the table.
>
> > -----Original Message-----
> > From: Anna Li [mailto:[EMAIL PROTECTED]
> >
> > I created a unique index on a table called REGISTRATION_K,
> > but no unique
> > constraint. Last week when the application tried to insert a
> > record into
> > the table, we got following error in the log file:
> >
> > Oracle::st execute failed: ORA-00001: unique constraint
> > (REGISTRATION_K)
> > violated
> >
> > However, the record was inserted into the table successfully.
> > There are no
> > duplicate records in the table. Could anyone explain why?
> >
> > Any input will be highly appreciated. Thanks in advance.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jacques Kilchoer
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Jul 08 2003 - 08:36:06 CDT
 |
 |