Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\sql_utl_comp_schema.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>Comparing Schemas</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:10:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Comparing Schemas" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12511-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="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="sql_utl.htm" title="Using Oracle Application Ex..." type="text/html" /> <link rel="up" href="sql_utl_comp_schema.htm" title="Comparing Schemas" type="text/html" /> <link rel="prev" href="sql_utl_apx_view.htm" title="Previous" type="text/html" /> <link rel="next" href="dbadm_montitor.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="sql_utl.htm" title="Using Oracle Application Ex...">Using Oracle Application Ex...</a> > Comparing Schemas</p> <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="sql_utl_apx_view.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="dbadm_montitor.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CBHEGADC" name="CBHEGADC"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL270" id="AEUTL270"></a>Comparing Schemas</h1> <p>You can run a report that compares database objects in two schemas, displaying differences between them. You can compare all objects in the schemas or limit your report to specific objects. To compare two schemas, both must be available to your workspace.</p> <p>Examples:</p> <ul> <li> <p>Compare <code>DEMO_</code> objects by searching for that naming convention. The report indicates if the object exists in each of the two schemas.</p> </li> <li> <p>Analyze the object details in the two schemas to determine why one implementation is different. For example, the report might show that an index in one schema has an additional column or a column with a different data type.</p> </li> </ul> <p>To compare schemas:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Utilities</span> icon.</p> </li> <li> <p>Click <span class="bold">Schema Comparison</span>.</p> </li> <li> <p>On the Schema Comparison page, make the appropriate selections to run the comparison:</p> <ul> <li> <p>Schema 1 and Schema 2 - Select the schemas to compare.</p> </li> <li> <p>Compare - Restrict the report to show one object type or select <span class="bold">All</span> to show all database objects.</p> </li> <li> <p>Search - Enter a case insensitive query for the object name.</p> </li> <li> <p>Display - To change the number of rows that appear in the report, make a selection from the Display list.</p> </li> <li> <p>Go - Click <span class="bold">Go</span> to find the results matching your selections.</p> </li> <li> <p>Show Differences Only or Show Details - Select the type of information you want to review.</p> </li> </ul> </li> </ol> </div> <!-- class="sect1" --> <!-- 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 © 2003, 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="sql_utl_apx_view.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="dbadm_montitor.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