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