Geek Answers Handbook

A violation of Oracle's unique constraint that refers to a constraint that does not seem to exist

I am getting an error that I cannot understand about. The error is pretty simple:

ORA-00001: unique constraint (*schema*.*xyz_constraint*) violated

However, what causes my confusion is that such a restriction does not exist. He is definitely not defined on the table; This database practically does not contain relational integrity, and the specific table into which I insert the data does not have a specific key.

For what it's worth, I can't find the restriction anywhere in the database:

    select *
    from all_constraints 
    where constraint_name like '%xyz_constraint%'

Is there anything I am missing? Thank.

+5
source share
2 answers

This happens when the restriction belongs to another user, and you do not have rights to it.

SYS

+4

.

select *
from all_constraints 
where constraint_name like '%XYZ_CONSTRAINT%'

ORA-00001 . , ?

+1

More articles:


All Articles