I have 5800 synonyms in our OLTP environment and about 1300 in our reporting environment. I have not found it difficult to manage (well not very - the wrapped database links are a little more work) and our application is always changing (or so it seems).
What's the big deal with herding cats. The sleep for like 23 1/2 hrs a day.
David Davis Manulife Financial
From: "Nelson, Allan" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Using fully qualified table_name.database_object in Date: Mon, 24 Feb 2003 10:18:53 -0800
Most application developers in my experience are in love with synonyms exactly so they won't have to fully qualify the table name. Oracle uses them fairly extensively in APPs. They do require some overhead for looking up the synonym and they can be a mess if nested deeply enough. Controlling use of synonyms on the other hand is a lot like herding cats.
Allan
-----Original Message----- From: laura pena [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 10:29 AM To: Multiple recipients of list ORACLE-L code?
I would like to know if it is advocated to use fully qualified table_name.database objects in application code.
Example would be schema.table_name in a PL/SQL code.
I would like to know the Pros/Cons if there are any?
Thanks in advance.
_____
Do you Yahoo!? Yahoo! <http://rd.yahoo.com/finance/mailtagline/*http://taxes.yahoo.com/> Tax Center - forms, calculators, tips, and more
______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
