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: 165

Filed under:
|
|
|

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

Related posts about sql

Related posts about Oracle