Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\TDPAX\td_gsintobj.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>Installing the Sample Objects</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:17:39Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Installing the Sample Objects" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11946-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.htm" title="Home" type="text/html" /> <link rel="up" href="get_start.htm" title="Getting Started with Oracle..." type="text/html" /> <link rel="up" href="td_gsintobj.htm" title="Installing the Sample Objects" type="text/html" /> <link rel="prev" href="td_gsappbld.htm" title="Previous" type="text/html" /> <link rel="next" href="build_app.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="get_start.htm" title="Getting Started with Oracle...">Getting Started with Oracle...</a> > Installing the Sample Objects</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="td_gsappbld.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="build_app.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABGAFBD" name="BABGAFBD"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="TDPAX03004|how to install the sample database objects"></a>Installing the <a id="sthref105" name="sthref105"></a><a id="sthref106" name="sthref106"></a><a id="sthref107" name="sthref107"></a><a id="sthref108" name="sthref108"></a>Sample Objects</h1> <p>In Oracle Application Express, users log in to a workspace. You can think of each workspace as a shared work area that separates your objects, data, and applications into a virtual private database.</p> <p>Before performing any tasks in this guide, you must create the appropriate sample objects within your workspace. These <a id="sthref109" name="sthref109"></a><a id="sthref110" name="sthref110"></a><a id="sthref111" name="sthref111"></a><a id="sthref112" name="sthref112"></a><a id="sthref113" name="sthref113"></a><a id="sthref114" name="sthref114"></a>sample objects are copies of the objects that are typically installed in two schemas:</p> <ul> <li> <p>Human Resources (HR)</p> <p>The HR schema contains information about the employees and the facilities where they work. Each employee has an identification number, email address, job identification code, salary, and manager. Employees are assigned to a department, and each department is associated with one location that has a full address, including the street name, postal code, city, state or province, and country code.</p> </li> <li> <p>Order Entry (OE)</p> <p>The OE schema tracks product inventories and sales of a company's products, including the product identification number, the product name, the associated associates product category, product descriptions, the weight group (for shipping purposes), the warranty periods, the suppliers, the availability status, and a minimum price.</p> </li> </ul> <p>To create the objects locally in your workspace, import the <span class="italic">OEHR Sample Objects</span> application.</p> <a id="sthref115" name="sthref115"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="#BABDJCJJ">Downloading OEHR Sample Objects</a></p> </li> <li> <p><a href="#BABGEDGF">Importing the OEHR Sample Objects</a></p> </li> <li> <p><a href="#CHDHCBIH">Viewing Your Database Objects</a></p> </li> </ul> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Tip:</p> In order to successfully import the objects associated with the <span class="italic">OEHR Sample Objects</span> application, your Oracle database must include Oracle Spatial. If your database instance does not include Oracle Spatial, you can install it using Database Configuration Assistant. To learn more, see the <span class="italic"><a href="http://www.oracle.com/pls/db112/lookup?id=HTMIG">Oracle Application Express Installation Guide</a></span> for your operating environment.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="BABDJCJJ" name="BABDJCJJ"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2>Downloading OEHR <a id="sthref116" name="sthref116"></a><a id="sthref117" name="sthref117"></a><a id="sthref118" name="sthref118"></a>Sample Objects</h2> <p>To import the <span class="italic">OEHR Sample Objects</span> application, you must download it from the Oracle Technology Network (OTN).</p> <p>To download the <span class="italic">OEHR Sample Objects</span> application from OTN:</p> <ol> <li> <p>In your Web browser, go to:</p> <pre xml:space="preserve" class="oac_no_warn"> <code><a href="http://www.oracle.com/technology/products/database/application_express/">http://www.oracle.com/technology/products/database/application_express/</a></code> </pre></li> <li> <p>Click <span class="bold">Packaged Applications</span>.</p> </li> <li> <p>Click <span class="bold">OEHR Sample Objects</span>.</p> </li> <li> <p>Download and save the <code>oehr_sample_objects.zip</code> file to your computer.</p> </li> <li> <p>Unzip and extract the <code>oehr_sample_objects_installer.sql</code> file:</p> <ul> <li> <p>Microsoft Windows - Double-click the <code>oehr_sample_objects.zip</code> file</p> </li> <li> <p>UNIX or Linux - Enter the following command:</p> <pre xml:space="preserve" class="oac_no_warn"> $ unzip oehr_sample_objects.zip </pre></li> </ul> </li> </ol> </div> <!-- class="sect2" --> <a id="BABGEDGF" name="BABGEDGF"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2>Importing the OEHR <a id="sthref119" name="sthref119"></a><a id="sthref120" name="sthref120"></a><a id="sthref121" name="sthref121"></a>Sample Objects</h2> <p>After you download and unzip the <span class="italic">OEHR Sample Objects</span> application, import it into Oracle Application Express. During the import process, specify installation of both the application and the supporting objects. Installing the application creates the objects and sample data needed to complete the exercises in this guide.</p> <p>To import and install the <span class="italic">OEHR Sample Objects</span> application:</p> <ol> <li> <p>Log in to Oracle Application Express.</p> <p>For instructions, see <a href="td_envdemo.htm#CACCEHAE">"Logging In to the Hosted Demo Environment"</a> or <a href="td_envlocal.htm#BEHCHGGB">"Logging In to Your Local Instance"</a>.</p> </li> <li> <p>On the Workspace home page, click <span class="bold">Application Builder</span>.</p> <p>The Application Builder home page appears.</p> </li> <li> <p>Click the <span class="bold">Import</span> button.</p> </li> <li> <p>For Specify File, specify the following:</p> <ol> <li> <p>Import file - Click <span class="bold">Browse</span> and navigate to the <code>oehr_sample_objects_installer.sql</code> file.</p> </li> <li> <p>File Type - Select <span class="bold">Application, Page, or Component Export</span>.</p> </li> <li> <p>File Character Set - Select the correct character set.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> </li> </ol> <p>Next, you must install the imported file.</p> </li> <li> <p>To install an imported file, click <span class="bold">Next</span>.</p> <p>The Install Application Wizard appears.</p> </li> <li> <p>In the Install Application Wizard, specify the following:</p> <ol> <li> <p>Parsing Schema - Select the schema you created when you set up your development environment.</p> </li> <li> <p>Build Status - Select <span class="bold">Run and Build Application</span>.</p> </li> <li> <p>Install As Application - Select <span class="bold">Auto Assign New Application ID</span>.</p> </li> <li> <p>Click <span class="bold">Install</span>.</p> </li> </ol> </li> <li> <p>For Install Supporting Objects, select <span class="bold">Yes</span> and click <span class="bold">Next</span>.</p> </li> <li> <p>Confirm your selections by clicking <span class="bold">Install</span>.</p> </li> <li> <p>After the installation is completed, click the <span class="bold">Home</span> breadcrumb link at the top of the page.</p> <p>The Application Builder home page appears.</p> </li> </ol> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref122" name="sthref122"></a> <h3>Checking Your Workspace <a id="sthref123" name="sthref123"></a><a id="sthref124" name="sthref124"></a><a id="sthref125" name="sthref125"></a><a id="sthref126" name="sthref126"></a><a id="sthref127" name="sthref127"></a>Storage Space</h3> <p>If you experience problems installing the <span class="italic">OEHR Sample Objects</span> application, verify the available space in your workspace. If you do not have enough space, request additional storage space.</p> <p>If you are a workspace administrator, you can:</p> <ul> <li> <p>Determine if you have enough storage space. See "Viewing the Workspace Overview Report" in <span class="italic"><a href="../AEADM/aadm_wrkspc_rprt.htm">Oracle Application Express Administration Guide</a></span>.</p> </li> <li> <p>Request additional storage space. See "Requesting Additional Storage" in <span class="italic"><a href="../AEADM/aadm_storage_request.htm">Oracle Application Express Administration Guide</a></span>.</p> </li> </ul> </div> <!-- class="sect3" --> <a id="BABBBBEA" name="BABBBBEA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h3>Deleting the <a id="sthref128" name="sthref128"></a><a id="sthref129" name="sthref129"></a><a id="sthref130" name="sthref130"></a>OEHR Sample Objects Application</h3> <p>Deleting the <span class="italic">OEHR Sample Objects</span> application and deinstalling the supporting objects completely removes all associated objects and sample data.</p> <p>To delete the <span class="italic">OEHR Sample Objects</span> application:</p> <ol> <li> <p>Log in to Oracle Application Express.</p> </li> <li> <p>On the Workspace home page, click <span class="bold">Application Builder</span>.</p> <p>The Application Builder home page appears.</p> </li> <li> <p>Click the <span class="bold">OEHR Sample Objects</span> icon.</p> </li> <li> <p>On the Tasks list, click <span class="bold">Delete this Application</span>.</p> <p>The Deinstall page appears.</p> </li> <li> <p>To remove all associated objects and sample data, select <span class="bold">Remove Application Definition</span> and <span class="bold">Deinstall Supporting Objects</span>.</p> </li> <li> <p>Click <span class="bold">Deinstall</span>.</p> </li> </ol> </div> <!-- class="sect3" --> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref131" name="sthref131"></a> <h3>Using <a id="sthref132" name="sthref132"></a>HR Schema Instead of OEHR Sample Objects</h3> <p>If you are using a locally installed instance of Oracle Application Express release 2.2.1.1 or later (not a hosted demo environment such as <code><a href="http://apex.oracle.com">http://apex.oracle.com</a></code>) and have the HR schema installed, you can perform the exercises in this guide directly against the HR schema.</p> <p>To do so, you must associate the HR schema with your workspace instead of performing the steps described in <a href="#BABGEDGF">"Importing the OEHR Sample Objects"</a>.</p> <div align="center"> <div class="inftblnote"><br /> <table class="Note oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Note:</p> The table names in the HR schema do not include the <code>OEHR</code> prefix (<code>EMPLOYEES</code> versus <code>OEHR_EMPLOYEES</code>). Because this guide outlines all the steps using the OEHR schema, you must adjust your selections and code accordingly. <p>Also, note that other users may be using the HR schema. Therefore, the objects or data within the objects may differ from that shown in this guide.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnote" --></div> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="CHDHCBIH" name="CHDHCBIH"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2>Viewing Your <a id="sthref133" name="sthref133"></a><a id="sthref134" name="sthref134"></a><a id="sthref135" name="sthref135"></a>Database Objects</h2> <p>Review the objects you just created by going to Object Browser. Object Browser enables you to browse, create, and edit objects in your database.</p> <p>To view the objects:</p> <ol> <li> <p>On the Workspace home page, click <span class="bold">SQL Workshop</span>.</p> </li> <li> <p>Click <span class="bold">Object Browser</span>.</p> <p>Object Browser appears.</p> <img src="img/o_brws_oehr.gif" alt="Description of o_brws_oehr.gif follows" title="Description of o_brws_oehr.gif follows" longdesc="img_text/o_brws_oehr.htm" /><br /> <a id="sthref136" name="sthref136" href="img_text/o_brws_oehr.htm">Description of the illustration o_brws_oehr.gif</a><br /> <br /> <p>Object Browser is divided into two sections:</p> <ul> <li> <p>Object Selection pane displays on the left side of the Object Browser page and lists database objects of a selected type within the current schema.</p> </li> <li> <p>Detail pane displays to the right of the page and displays detailed information about a selected object.</p> </li> </ul> </li> <li> <p>From the list <a id="sthref137" name="sthref137"></a>in the Object Selection pane on the left, select <span class="bold">Tables</span>.</p> <p>The Detail pane lists the tables in your current schema.</p> </li> <li> <p>In the <a id="sthref138" name="sthref138"></a>Object Selection pane, click <span class="bold">OEHR_EMPLOYEES</span> from the list.</p> <p>The Detail pane shows details about the table.</p> </li> <li> <p>Click the <span class="bold">Data</span> tab at the top of the Details pane.</p> <p>The data in the <code>OEHR_EMPLOYEES</code> table appears. Note that other tabs show additional details about the object you select.</p> </li> <li> <p>To search for an object name, enter a case-insensitive term in the Search field.</p> <img src="img/o_brws_srch_oehr.gif" alt="Description of o_brws_srch_oehr.gif follows" title="Description of o_brws_srch_oehr.gif follows" longdesc="img_text/o_brws_srch_oehr.htm" /><br /> <a id="sthref139" name="sthref139" href="img_text/o_brws_srch_oehr.htm">Description of the illustration o_brws_srch_oehr.gif</a><br /> <br /></li> <li> <p>To view all objects, leave the Search field blank.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See also:</p> "Managing Database Objects with Object Browser" in <a href="../AEUTL/obj_brows.htm"><span class="italic">Oracle Application Express SQL Workshop and Utilities Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect2" --></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="td_gsappbld.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="build_app.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