RE: renaming Constraints

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 19 Nov 2001 05:57:03 -0800
Message-ID: <F001.003C863D.20011119043518@fatcity.com>

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: mark_at_cool-tools.co.uk

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: ListGuru_at_fatcity.com (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).

Received on Mon Nov 19 2001 - 07:57:03 CST