Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Unique Constraint(SO_LINES_N10) Violated but Index is NOT Unique!
Well this is one for the gurus' here.
I am getting an ORA error "unique constraint (SO_LINES_N10) violated". However poking at the index with TOAD shows that this index is indeed not unique. The TRM for that module also lists that index as non-unique.
I have sent the trace files to Oracle customer support but so far they've come up blank - seems that the trace files just confirm that a unique constraint is violated.
Jonathan? Anybody? Help!
Philip (just spent four hours 10pm to 2am on Y2K watch at the office)
---=====================================================================---
Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA
e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932
Guard us from the she-wolf and the wolf, and guard us from the thief,
oh Night, and so be good for us to pass.