Arslan, This is from the "SearchDatabase.com DBA Tip Newsletter" (www.searchdatabase.com). I haven't tried it myself though..
-------------------------- "Renaming foreign keys" By Terry Plantz Here is a script that renames foreign keys from system-assigned constraint names to more intelligible names. The names use the current table name and the referenced table name. This greatly improves readability, especially for error messages. The complete script is too long to list here, so click the link below to view it online: http://www.searchDatabase.com/tip/1,289483,sid13_gci759997,00.html -------------------------- HTH Mark -----Original Message----- Sent: 19 November 2001 11:11 To: Multiple recipients of list ORACLE-L 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).