Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEADM\adm_eng_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>Determining the Oracle Application Express Engine Schema</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:6:25Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Determining the Oracle Application Express Engine Schema" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12512-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="adm_wrkspc.htm" title="Oracle Application Express ..." type="text/html" /> <link rel="up" href="adm_schema.htm" title="Managing Schemas" type="text/html" /> <link rel="up" href="adm_eng_schema.htm" title="Determining the Oracle Appl..." type="text/html" /> <link rel="prev" href="adm_schema.htm" title="Previous" type="text/html" /> <link rel="next" href="adm_schema_restrict.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="adm_wrkspc.htm" title="Oracle Application Express ...">Oracle Application Express ...</a> > <a href="adm_schema.htm" title="Managing Schemas">Managing Schemas</a> > Determining the Oracle Appl...</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="adm_schema.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="adm_schema_restrict.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BEJEDCEJ" name="BEJEDCEJ"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEADM231" id="AEADM231"></a>Determining the Oracle Application Express Engine <a id="sthref252" name="sthref252"></a><a id="sthref253" name="sthref253"></a>Schema</h1> <p>A schema is a logical container for the database objects. Oracle Application Express administrators may need to perform certain actions within the Application Express engine schema. For example, in order for an Oracle Application Express administrator to have the ability to assign Oracle default schemas, the database administrator (DBA) must explicitly grant the privilege by running the <code>APEX_SITE_ADMIN.UNRESTRICT_SCHEMA</code> procedure within the Application Express engine.</p> <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> <a href="adm_schema_restrict.htm#BEJEFJAE">"Understanding Oracle Default Schema Restrictions"</a> for information about the <code>APEX_SITE_ADMIN.UNRESTRICT_SCHEMA</code> procedure</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>To determine the current Application Express engine schema for your Oracle Application Express instance:</p> <ol> <li> <p>Use SQL*Plus to connect to the database.</p> </li> <li> <p>Run the following query in a schema with DBA privileges (for example, <code>SYSTEM</code>).</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT TABLE_OWNER FROM all_synonyms WHERE SYNONYM_NAME = 'WWV_FLOW' and OWNER = 'PUBLIC' </pre></li> </ol> </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 © 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="adm_schema.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="adm_schema_restrict.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