Database Administration (MOSC)

MOSC Banner

ORA-00001: unique constraint (owner.IDX) violated => owner.idx is not a constraint.

edited May 5, 2009 5:01AM in Database Administration (MOSC) 8 commentsAnswered
hi
oracle return the error ORA-00001: unique constraint (owner.IDX_NAME) violated to my application. but owner. IDX_NAME is not a constraint and is not a unique index.
I verify in
dba_indexes, the index IDX_NAME is not unique,
dba_constraints, the contraints IDX_NAME does not exist


what-is the problem ?

thanks for your help,
Pascal

edit because I forget ORacle 10.2.0.4 on linux x86_64 bits Read 2.6.9-67.ELsmp


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center