Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\ja\AEADM\adm_wrkspc_del.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="ja" lang="ja"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>??????????????????????????????</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="About Deleting Inactive Workspaces" /> <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_mg_wrkspc.htm" title="Managing Existing Workspaces" type="text/html" /> <link rel="up" href="adm_wrkspc_del.htm" title="About Deleting Inactive Wor..." type="text/html" /> <link rel="prev" href="adm_wrkspc_privs.htm" title="Previous" type="text/html" /> <link rel="next" href="adm_wrkspc_remove.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="?????">?????</a> > <a href="adm_wrkspc.htm" title="Oracle Application Express???????????????????????????">Oracle Application Express???????????????????????????</a> > <a href="adm_mg_wrkspc.htm" title="???????????????">???????????????</a> > ??????????????????????????????</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_wrkspc_privs.htm"><img src="../dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="adm_wrkspc_remove.htm"><img src="../dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td> </tr> </table> <p><a id="BEJHHADG" name="BEJHHADG"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEADM276" id="AEADM276"></a>??????????????????????????????<a id="sthref337" name="sthref337"></a><a id="sthref338" name="sthref338"></a></h1> <p>????????????????????racle Application Express????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????</p> <ol> <li> <p>???????????????????????????????</p> </li> <li> <p>????????????????????????????????????????????????????</p> </li> <li> <p>???????????????????????????????</p> </li> </ol> <a id="sthref339" name="sthref339"></a> <p class="subhead2">??????:</p> <ul> <li> <p><a href="#BEJCJIJI">????????????????????????</a></p> </li> <li> <p><a href="#BEJJGHEB">??????????????????????????????????????????????</a></p> </li> <li> <p><a href="#BEJHCAEG">????????????????????????</a></p> </li> </ul> <a id="BEJCJIJI" name="BEJCJIJI"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM277" id="AEADM277"></a>????????????????????????<a id="sthref340" name="sthref340"></a></h2> <p>??????????????????????????????????????????????????????????????????????????????????pplication Express??????????????????????????racle Application Express????????????????????????????????????????????????????</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">???:</p> <a href="adm_eng_schema.htm#BEJEDCEJ">??racle Application Express????????????????????</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <p>?°?DDL??????????????????????2004??6??28???????????????????2004??6??10?????????????????????????????????????????????????????????????????Application Express?????????????????????????????????????????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> ALTER SESSION SET CURRENT_SCHEMA = APEX_030200; CREATE TABLE ws_to_purge AS SELECT c.security_group_id, c.company_name, c.admin_email, c.request_date, SYSDATE last_updated_on, 'Y' ok_to_delete FROM wwv_flow_provision_company c WHERE c.request_date <= to_date('20040628','YYYYMMDD') AND ( not exists (SELECT NULL /* Activity Log */ FROM wwv_flow_activity_log l WHERE l.security_group_id = c.security_group_id AND l.time_stamp > to_date('20040610','YYYYMMDD')) ) AND NOT EXISTS (SELECT NULL /* workspace applications */ FROM wwv_flows f WHERE f.security_group_id = c.security_group_id AND f.last_updated_on > to_date('20040610','YYYYMMDD')) AND NOT EXISTS (SELECT NULL /* Pages */ FROM wwv_flow_steps s WHERE s.security_group_id = c.security_group_id AND s.last_updated_on > to_date('20040610','YYYYMMDD')) AND NOT EXISTS (SELECT NULL /* Regions */ FROM wwv_flow_page_plugs p WHERE p.security_group_id = c.security_group_id AND p.last_updated_on > to_date('20040610','YYYYMMDD')) AND NOT EXISTS (SELECT NULL /* Items */ FROM wwv_flow_step_items i WHERE i.security_group_id = c.security_group_id AND i.last_updated_on > to_date('20040610','YYYYMMDD')) AND NOT EXISTS (SELECT NULL /* Templates */ FROM wwv_flow_templates t WHERE t.security_group_id = c.security_group_id AND t.last_updated_on > to_date('20040610','YYYYMMDD')) AND NOT EXISTS (SELECT NULL /* Files uploaded */ FROM wwv_flow_file_objects$ o WHERE o.security_group_id = c.security_group_id AND o.created_on > to_date('20040610','YYYYMMDD')) AND NOT EXISTS (SELECT NULL /* SQL Workshop history */ FROM wwv_flow_sw_sql_cmds s WHERE s.security_group_id = c.security_group_id AND s.created_on > to_date('20040610','YYYYMMDD')); </pre> <p>???????????????????????????????????????????????????2????????????????????????????????????????????</p> <ul> <li> <p>???????????????????????????????????????????????????????????????????????????????????????????????????</p> </li> <li> <p>?°????????????????????????racle Application Express?????????????</p> </li> </ul> </div> <!-- class="sect3" --> <a id="BEJJGHEB" name="BEJJGHEB"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM278" id="AEADM278"></a><a id="sthref341" name="sthref341"></a>??????????????????????????????????????????????</h2> <p>?????????????????????1???????????????????????????????</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">???:</p> ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnote" --></div> <p>??????????????????????????????????????????????????????????????????????????</p> <ol> <li> <p>???????????????????????????????????????<code>wwv_flow_company_schemas</code>???????????????????????????????????????????????????</p> </li> <li> <p>?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT s.schema FROM ws_to_purge ws, wwv_flow_company_schemas s WHERE s.security_group_id = ws.security_group_id AND ws.ok_to_delete = 'Y'; </pre></li> </ol> </div> <!-- class="sect3" --> <a id="BEJHCAEG" name="BEJHCAEG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="AEADM279" id="AEADM279"></a>????????????????????????<a id="sthref342" name="sthref342"></a></h2> <p>????????????????????????????????????????????????????????????????????????????????????????????????racle Application Express??????????????????????????????????????????????????????L/SQL??????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN FOR c1 IN (SELECT security_group_id FROM ws_to_purge WHERE ok_to_delete = 'Y') LOOP WWV_FLOW_PROVISIONING.TERMINATE_SERVICE_BY_SGID(c1.security_group_id); END LOOP; END; </pre> <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">???:</p> <a href="adm_wrkspc_remove.htm#BABHCJHA">??????????????</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --></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 (C) 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"> <span class="copyrightlogo">???????????</span></a></td> <td align="center"><a href="adm_wrkspc_privs.htm"><img src="../dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="adm_wrkspc_remove.htm"><img src="../dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</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