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 the application reporting time is taken from a different source than the time used to populate date_created (e.g. the application uses a PC client clock to report errors, and date_created is sysdate from the database server) then the two times will not necessarily match.
Not creating unique indexes on tables - I agree with Ms. Carmichael that if you read that statement, what was probably meant was create constraints to enforce uniqueness, and not indexes (though as you will have noticed Oracle will use an index to enforce the constraint, and "automagically" create the index if necessary.) > -----Original Message----- > From: Anna Li [mailto:[EMAIL PROTECTED] > Sent: mardi, 8. juillet 2003 07:09 > > 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? -- 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).
