user_objects oracle
Posted
by
mysticfalls
on Stack Overflow
See other posts from Stack Overflow
or by mysticfalls
Published on 2012-07-10T09:13:13Z
Indexed on
2012/07/10
9:15 UTC
Read the original article
Hit count: 169
I would just like to ask what is the difference between user_constraints and user_objects. I have this two database. I run a script on both DB that resulted a unique constraint error. To solve the problem I delete the constraint on user_constraint table for both DB. After that DB1 run without error.. DB2 however failed, I checked the user_constraint for both db and the constraints was deleted. I was asked to check the user_objects.. and found that DB2 has that same constraint_name as the object_name in user_objects table.. Any info regarding their relationship, use, similarites, etc will be appreciated ... Thanks..
© Stack Overflow or respective owner