Hi All,
Running Xe 11.2
I'm trying to add a row to a table with a unique value after previously deleting the same value, and Im getting the above error Unique Constraint violated. Ive checked very carefully that the value doesn't now exist... (its a pretty simple 8 digit number) I cannot figure out why I would still get this error?
I'm just about to drop and recreate the unique constraint, to recreate the index to see if this solves the problem, but would like to find out why I'm getting the error....
Any ideas, or ways I can diagnose this, Id be grateful.
Many Thanks
Richard