I think you'll find that what Oracle actually says is that rather than
define a unique index, you should define a unique constraint (which
does create a unique index to enforce the constraint)
there is no recommendation, that I have heard of, that you do not
define uniqueness on columns other than the primary key column
- Anna Li <[EMAIL PROTECTED]> wrote:
> 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).
> >
>
> _________________________________________________________________
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus
>
> --
> 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).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
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:55:52 CDT
