Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_deploying010.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 Package" /> <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_deploying009.htm" title="Previous" type="text/html" /> <link rel="next" href="tdddg_deploying011.htm" title="Next" type="text/html" /> <title>Tutorial: Creating an Installation Script File for the Package</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_deploying009.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_deploying011.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="BABJEDAD" name="BABJEDAD"></a><a id="TDDDG74300" name="TDDDG74300"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Tutorial: Creating an Installation Script File for the Package</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref726" name="sthref726"></a>This tutorial shows how to use the SQL Developer tool Database Export to create an installation script file for the package (specification and body) of the sample application.</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="TDDDG274" name="TDDDG274"></a> <p class="subhead2">To create an installation script file for the package:</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="CEGBGCAJ" name="CEGBGCAJ"></a> <p>In the Source/Destination window:</p> <ol> <li> <p>In the File field, type: <code>C:\my_exports\2day_package.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> Package Spec and Package Body.</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>, accept that value.</p> </li> <li> <p>Click <span class="bold">Go</span>.</p> <p>A list of the packages and package bodies in schema <code>HR</code> appears.</p> </li> <li> <p>If the only items listed are the package <code>HR</code>.<code>EMP_EVAL</code> and the package body <code>HR</code>.<code>EMP_EVAL</code>, click <span class="bold">>></span>; otherwise, select those two items from the list and click <span class="bold">></span>.</p> <p>The package <code>HR</code>.<code>EMP_EVAL</code> and the package body <code>HR</code>.<code>EMP_EVAL</code> move from the original column to the other column.</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 installation script file that you specified in step <a href="#CEGBGCAJ">4</a>.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdddg_subprograms015.htm#CIHIEAGC">Tutorial: Changing a Package Specification</a></p> <p><a href="tdddg_subprograms016.htm#BABEIAGI">Tutorial: Creating a Package Body</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_deploying009.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_deploying011.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