Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00001: unique constraint (10.2.0.2 solaris)
ORA-00001: unique constraint [message #350033] Tue, 23 September 2008 16:58 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi,
I am trying to add one record and I am getting :-
(BV7PROD.BV_USER_ALIAS_INDEX) violated
I deleted the record before inserting.So there is not
duplicate data present.What could be the reason of error.
Regards,
Varun Punj
Re: ORA-00001: unique constraint [message #350056 is a reply to message #350033] Tue, 23 September 2008 23:55 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In that case, it must be that you have installed a dirty, lying Oracle database version. Next time make sure to install a truthful version.
Re: ORA-00001: unique constraint [message #350149 is a reply to message #350033] Wed, 24 September 2008 04:09 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If Oracle says there is a unique constraint violation, and you believe that there isn't, then your first assumption should be that you are wrong.

1)Check that the record is definitely gone.
2) Check that you committed the delete if you are inserting from a different session.
3)Check which constraint is being vilated - if you've got triggers on your tables, it might not be the constraint you think it is.
4) cust and post an SQL*Plus session showing you deleting the record, confirming it is deleted, and then insterting a new one.
Re: ORA-00001: unique constraint [message #350226 is a reply to message #350033] Wed, 24 September 2008 07:58 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I loved this line, so true:

"If Oracle says there is a unique constraint violation, and you believe that there isn't, then your first assumption should be that you are wrong."
Re: ORA-00001: unique constraint [message #350229 is a reply to message #350033] Wed, 24 September 2008 08:07 Go to previous message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
I did too ...
Previous Topic: Problem with packages between Users
Next Topic: SQL help
Goto Forum:
  


Current Time: Fri Dec 09 15:45:11 CST 2016

Total time taken to generate the page: 7.24784 seconds