From John.Hallas@btcellnet.net Mon, 19 Nov 2001 06:28:45 -0800 From: Hallas John Date: Mon, 19 Nov 2001 06:28:45 -0800 Subject: RE: renaming Constraints Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: renaming Constraints Presumably if it is development then the developers should be preparing proper scripts to create the objects once the names and definitions are finalised. Just ask them for the latest set of scripts and then write some dynamic sql to drop the constraints and then run the scripts to recreate the objects.   I would not start updating the data dictionary directly if I were you. Totally unsupported, undesirable and unnecessary in this (and most ) cases.   John -----Original Message-----From: Arslan Dar [mailto:arslandar@skm.org.pk]Sent: 19 November 2001 11:11To: Multiple recipients of list ORACLE-LSubject: renaming Constraints Hi list, is there any easiar way to rename a constraint other then dropping and then recreating it, cuz in our environment, developers mess up the constraints with naming them using system assigned names and then after finilizing the tables and relations, i have to drop/recreate all the constraints following the naming convetion for them. is there any easiar way, like updating the data dictionary directly, any harm in that, if not, which are the key tables i am supposed to play with? Thanks in Advance Arslan ********************************************************************** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **********************************************************************