Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_distdbs003.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>About Synonyms and Location Transparency</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T17:1:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Synonyms and Location Transparency" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10703-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdpii_distdbs002.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_distdbs004.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdpii_distdbs002.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_distdbs004.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHJFJFE" name="CIHJFJFE"></a><a id="TDPII123" name="TDPII123"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>About Synonyms and Location Transparency<a id="sthref42" name="sthref42"></a><a id="sthref43" name="sthref43"></a><a id="sthref44" name="sthref44"></a><a id="sthref45" name="sthref45"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>A <span class="bold">synonym</span> is a database object that acts as an alias for another database object. You can create both public and private synonyms. Every database user can access a public synonym. A private synonym is in the schema of a specific user, and only users who are granted access to the private synonym can use it.</p> <p>In a distributed environment, synonyms can provide location transparency for database objects. A synonym hides the location of a database object from applications and users. If the database object must be moved or renamed, then you can redefine the synonym, and applications and users can continue to use the synonym without any modifications.</p> <p>For example, suppose an application must access the <code>hr.employees</code> table at a remote database with the global name <code>ii2.example.com</code>. A database link exists for the remote database, and the name of the database link is <code>ii2.example.com</code>. In this case, you can create a synonym named <code>employees</code> in the <code>hr</code> schema that points to the table <code>hr.employees@ii2.example.com</code>. After the synonym is in place, the application at the local database can use <code>hr.employees</code> to access the remote table.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_distdbs006.htm#BABJDEED">Preparing to Access and Modify Information in Multiple Oracle Databases</a></p> <p><a href="tdpii_distdbs007.htm#BABFJGFG">Tutorial: Querying Multiple Oracle Databases</a></p> <p><a href="tdpii_distdbs008.htm#BABCCCGB">Tutorial: Modifying Data in Multiple Oracle Databases</a></p> <p><a href="tdpii_distdbs009.htm#BABFCFJJ">Tutorial: Running a Stored Procedure in a Remote Oracle Database</a></p> <p><a href="tdpii_common_ii006.htm#BGBGIACD">Tutorial: Creating a Database Link</a></p> </div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2007, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdpii_distdbs002.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_distdbs004.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de