Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_deploying012.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:26Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Tutorial: Creating an Installation Script File for the Data" /> <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_deploying011.htm" title="Previous" type="text/html" /> <link rel="next" href="tdddg_deploying013.htm" title="Next" type="text/html" /> <title>Tutorial: Creating an Installation Script File for the Data</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_deploying011.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_deploying013.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="CEGIHAJF" name="CEGIHAJF"></a><a id="TDDDG75000" name="TDDDG75000"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Tutorial: Creating an Installation Script File for the Data</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref728" name="sthref728"></a>This tutorial shows how to use the SQL Developer tool Database Export to create an installation script file for the data of the sample application. If you followed the instructions in this document, you added data only to the table <code>PERFORMANCE_PARTS</code>.</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="TDDDG276" name="TDDDG276"></a> <p class="subhead2">To create an installation script file for the data:</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> <p>In the Source/Destination window:</p> <ol> <li> <p>In the File field, type: <code>C:\my_exports\2day_data.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> Data.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> <p>The Specify Data window appears.</p> </li> <li> <p>In the Specify Data window:</p> <ol> <li> <p>In the drop-down menu with the value <code>HR</code>, accept that value.</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>.</p> </li> <li> <p>Click <span class="bold">></span>.</p> <p><code>HR</code>.<code>PERFORMANCE_PARTS</code> moves 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 file <code>C:\my_exports\2day_data.sql</code>.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdddg_dml002.htm#BABCCIEG">About the INSERT Statement</a></p> <p><a href="tdddg_deploying006.htm#BABBIDCB">Creating an Installation Script File with SQL Developer</a></p> <p><a href="tdddg_deploying.htm#CIHIGEDF">Deploying an Oracle Database Application</a></p> </div> </div> <!-- class="sect2" --> <!-- 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 © 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_deploying011.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_deploying013.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