Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_deploying009.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"> <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> <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" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-04-21T9:46:25Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Tutorial: Creating an Installation Script File for the Sequence and Tables" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10766-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="tdddg_deploying008.htm" title="Previous" type="text/html" /> <link rel="next" href="tdddg_deploying010.htm" title="Next" type="text/html" /> <title>Tutorial: Creating an Installation Script File for the Sequence and Tables</title> </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="tdddg_deploying008.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdddg_deploying010.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABEBFDI" name="BABEBFDI"></a><a id="TDDDG74200" name="TDDDG74200"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Tutorial: Creating an Installation Script File for the Sequence and Tables</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref725" name="sthref725"></a>This tutorial shows how to use the SQL Developer tool Database Export to create an installation script file for the tables and sequence of the sample application, including the constraints, indexes, and triggers associated with the tables.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>In the following procedure, you might have to enlarge the SQL Developer windows to see all fields and options.</p> </div> <a id="TDDDG273" name="TDDDG273"></a> <p class="subhead2">To create an installation script file for the tables and sequence:</p> <ol> <li> <p>If you have not done so, create the directory <code>C:\my_exports</code>.</p> </li> <li> <p>In the SQL Developer window, click the menu <span class="bold">Tools</span>.</p> <p>A drop-down menu appears.</p> </li> <li> <p>From drop-down menu, select <span class="bold">Database Export</span>.</p> <p>The Source/Destination window opens.</p> </li> <li><a id="CEGFAJFI" name="CEGFAJFI"></a> <p>In the Source/Destination window:</p> <ol> <li> <p>In the File field, type: <code>C:\my_exports\2day_tables.sql</code>.</p> </li> <li> <p>From the Connections drop-down menu, select <span class="bold">hr_conn</span>.</p> </li> <li> <p>Accept the default DDL Options, Terminator and Pretty Print.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> <p>The Types to Export window appears.</p> </li> <li> <p>In the Types to Export window:</p> <ol> <li> <p>Deselect all check boxes <span class="italic">except</span> Tables, Sequences, Indexes, Constraints, and Triggers.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> <p>The Specify Objects window appears.</p> </li> <li> <p>In the Specify Objects window:</p> <ol> <li> <p>In the drop-down menu with the value <code>HR</code>, accept that value.</p> </li> <li> <p>In the drop-down menu with the value <code>All</code>, select the value <span class="bold">TABLE</span>.</p> </li> <li> <p>Click <span class="bold">Go</span>.</p> <p>A list of the tables in schema <code>HR</code> appears.</p> </li> <li> <p>Select <span class="bold">HR</span>.<span class="bold">PERFORMANCE_PARTS</span>, <span class="bold">HR</span>.<span class="bold">EVALUATIONS</span>, <span class="bold">HR</span>.<span class="bold">SCORES</span>, and <span class="bold">HR</span>.<span class="bold">EVALUATIONS_LOG</span>.</p> </li> <li> <p>Click <span class="bold">></span>.</p> <p>The selected tables move from the original column to the other column.</p> </li> <li> <p>In the drop-down menu with the value <code>TABLE</code>, select the value <span class="bold">SEQUENCE</span>.</p> </li> <li> <p>Click <span class="bold">Go</span>.</p> <p>A list of the sequences in schema <code>HR</code> appears.</p> </li> <li> <p>Select <span class="bold">HR</span>.<span class="bold">EVALUATIONS_SEQ</span>.</p> </li> <li> <p>Click <span class="bold">></span>.</p> <p><code>HR</code>.<code>EVALUATIONS_SEQ</code> moves from the original column to the other column.</p> </li> <li> <p>(Optional) In the drop-down menu with the value <code>SEQUENCE</code>, select the value <span class="bold">All</span>.</p> <p><code>HR</code>.<code>PERFORMANCE_PARTS</code>, <code>HR</code>.<code>EVALUATIONS</code>, <code>HR</code>.<code>SCORES</code>, <code>HR</code>.<code>EVALUATIONS_LOG</code> and <code>HR</code>.<code>EVALUATIONS_SEQ</code> show.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> <p>The Export Summary window appears.</p> </li> <li> <p>In the Export Summary window, click <span class="bold">Finish</span>.</p> <p>The Exporting window opens, showing that exporting is occurring. When exporting is complete, the Exporting window closes, and the SQL Worksheet shows the contents of the file <code>C:\my_exports\2day_tables.sql</code>.</p> </li> <li> <p>In the installation script file, <code>C:\my_exports\2day_tables.sql</code>, check that referenced objects are created before their dependent objects:</p> <ul> <li> <p>The sequence <code>EVALUATIONS_SEQ</code> must be created before the table <code>EVALUATIONS</code>, because <code>EVALUATIONS</code> has a trigger, <code>NEW_EVALUATION_TRIGGER</code>, that uses <code>EVALUATIONS_SEQ</code>.</p> </li> <li> <p>The table <code>EVALUATIONS_LOG</code> must be created before the table <code>EVALUATIONS</code>, because <code>EVALUATIONS</code> has a trigger, <code>EVAL_CHANGE_TRIGGER</code>, that uses <code>EVALUATIONS_LOG</code>.</p> </li> <li> <p>The tables <code>EVALUATIONS</code> and <code>PERFORMANCE_PARTS</code> must be created before the table <code>SCORES</code>, because <code>SCORES</code> has foreign keys to both <code>EVALUATIONS</code> and <code>PERFORMANCE_PARTS</code>.</p> </li> </ul> <p>If necessary, edit the file in the SQL Worksheet or any text editor.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdddg_objects005.htm#BABFEIDE">Creating Tables</a></p> <p><a href="tdddg_objects026.htm#BABJIDEG">Tutorial: Creating a Sequence</a></p> <p><a href="tdddg_deploying006.htm#BABBIDCB">Creating an Installation Script File with SQL Developer</a></p> <p><a href="tdddg_deploying005.htm#BABIIBHE">Creating Installation Script Files</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 © 1996, 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="tdddg_deploying008.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdddg_deploying010.htm"><img width="24" height="24" 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