REVISIT: FK Constraint naming.
Hi List, A few weeks ago somebody sent a message to the list about the naming of FK constraints to something other than the system generated names. I have come across a pretty nifty script that will do this for you automatically - check it out: http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci759997,00.html HTH whoever asked.. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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).
REVISIT: FK Constraint naming.
Hi List, A few weeks ago somebody sent a message to the list about the naming of FK constraints to something other than the system generated names. I have come across a pretty nifty script that will do this for you automatically - check it out: http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci759997,00.html HTH whoever asked.. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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).
RE: constraint naming
That's precisely the point - we have a bunch of system-generated names that we'd like to change to meaningful names... g -Original Message- Sent: Tuesday, July 24, 2001 2:32 PM To: Multiple recipients of list ORACLE-L g, Why use system generated FK names. does SYS12345 maen any thing to you? We always generate our FK with an ALTER TABLE command and name the FK with something that can be recognized. Very usefull when you have to drop the FK to accomplish an import of data. ROR mª¿ªm [EMAIL PROTECTED] 07/24/01 05:21AM O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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).
constraint naming
O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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).
Re: constraint naming
Guy, Per bug 15148 this is scheduled for 9.0.2. I don't know of any supported method of doing this, other than dropping and recreating the constraint. HTH, -- Anita --- Guy Hammond [EMAIL PROTECTED] wrote: O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
Re: constraint naming
Guy Hammond wrote: O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 Foreign key you say? I think that for them updating sys.con$ should be relatively safe, I don't believe that there is any other place (contrarily to PK and UQ constraints) where the name appears and is used. If I where you I would export with ROWS=N, reimport into a test database, fiddle in the dictionary, export the result with ROWS=N again, check with imp SHOW=Y that it looks like what you want, drop all FKs on the prod database, and reimport on the prod with IGNORE=Y. Should keep the risk of screwing up something to a minimum. -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
Re: constraint naming
g, Why use system generated FK names. does SYS12345 maen any thing to you? We always generate our FK with an ALTER TABLE command and name the FK with something that can be recognized. Very usefull when you have to drop the FK to accomplish an import of data. ROR mª¿ªm [EMAIL PROTECTED] 07/24/01 05:21AM O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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).