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
: 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
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
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
In that case what happened is that a session inserted a row at 13:35:13 and another
session (or the same session) tried an insert at the same second. This is assuming
that the time reported from the application is taken from the same source as the time
used to populate column date_created. If
Anna,
A unique constraint is a unique index and vice-versa which will explain your
error message. Also, no there will be no duplicate records because you defined the
index as unique. I would doubt your statement about the record being inserted
although the application may have
Anna Li wrote:
Hi,
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-1: unique constraint
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