Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\schema\partitions\indexPartitionsGR.jsp

<%--
  -- Page:        indexPartitionsGR.jsp
  -- Controller:  db/adm/schm/IndexPartitionsController.java
  --
  -- Description: Create/Edit Global-Range index partitions page
  --%>
<script language="JavaScript" src="/em/database/LOV.js"></script>

<%-- Tag Libraries --%>
<%@ taglib uri="http://xmlns.oracle.com/uix/ui" prefix="uix" %>
<%@ taglib uri="http://xmlns.oracle.com/oem/jsp/tag" prefix="oem" %>
<%@ taglib uri="http://xmlns.oracle.com/oem/jsp/tag/db" prefix="db" %>
<db:script src="/database/utils.js"/>

<uix:buildTree nodeID="indexPartitionsGR">

<%-- START: TAB CONTENTS starts here --%>

<%-- SWITCH: Create/Edit partitions --%>
  <uix:switcher childNameBinding="creating@objectBean@servletRequest">

<%-- CASE: Create partitions --%>
    <uix:case name="true">
      <uix:stackLayout>
        <uix:checkBox name="partsEnabled"
                      checkedBinding="partsEnabled@dataPartitionsBean@servletRequest"
                      onClick="submitForm('indexForm', true, {'event':'changeEnable'})"
                      textBinding="ENABLEPART@partitionsBundle" />
            <uix:rowLayout>
              <uix:flowLayout>
                <uix:spacer width="21" height="1" />
                <uix:styledText styleClass="OraInlineInfoText"
                                textBinding="IDX_PART_INSTR@partitionsBundle"/>
              </uix:flowLayout>
            </uix:rowLayout>

<uix:spacer height="5"/>

<%-- Partitioning method --%>
          <uix:rowLayout>
            <uix:cellFormat> 
              <uix:spacer height="1" width="20" />
            </uix:cellFormat>

<uix:cellFormat hAlign="right">
              <uix:styledText textBinding="PMETHOD@partitionsBundle"
                              labeledNodeId="PMETHOD"
                              styleClass="OraPromptText" />

</uix:cellFormat>

<uix:cellFormat> 
              <uix:spacer height="1" width="5" />
            </uix:cellFormat>

<uix:cellFormat> 
              <uix:switcher childNameBinding="onlyGlobalRange@dataPartitionsBean@servletRequest">
                <uix:case name="false">
                  <uix:choice name="ptype" 
                              onChange="submitForm('indexForm', true, {'event':'changeType'})"
                              id="PMETHOD"
                              shortDescBinding="PMETHOD@partitionsBundle"
                              selectedValueBinding="selectedTypeInt@dataPartitionsBean@servletRequest"
                              disabledBinding="partsDisabled@dataPartitionsBean@servletRequest">

<uix:option textBinding="LOCAL@partitionsBundle"
                                renderedBinding="isOnPartitioned@dataPartitionsBean@servletRequest"
                                value="5" />
                    <uix:option textBinding="GLOBALRANGE@partitionsBundle"
                                value="6" />
                    <uix:option textBinding="GLOBALHASH@partitionsBundle"
                                renderedBinding="is10i@dataPartitionsBean@servletRequest"
                                value="7" />
                  </uix:choice>  
                </uix:case>
                <uix:case name="true">
                  <uix:styledText styleClass="OraDataText" 
                                  textBinding="GLOBALRANGE@partitionsBundle" />
                </uix:case>
              </uix:switcher>
           </uix:cellFormat>

</uix:rowLayout>

<uix:spacer height="5"/>

<%-- start : header --%>
          <uix:header textBinding="PMETHODGR@partitionsBundle">

<uix:rowLayout>
              <uix:styledText styleClass="OraInstructionText"
                              textBinding="GRDESC@partitionsBundle"/>
            </uix:rowLayout>
          </uix:header>

<%-- Indent --%>   
          <uix:rowLayout width="100%">
            <uix:cellFormat> 
              <uix:spacer height="1" width="20" />
            </uix:cellFormat>
            <uix:cellFormat hAlign="right">

<%-- start : header --%>
        <uix:header textBinding="PCOLS@partitionsBundle">

<%-- SWITCH: Columns available/No columns available --%>
          <uix:switcher childNameBinding="multiCols@partitionColsBean@servletRequest">
            <%-- CASE: Columns available to be added --%>
            <uix:case name="true">
              <uix:stackLayout>

<uix:rowLayout width="80%">
                <uix:styledText styleClass="OraInstructionText" 
                                textBinding="GRCOLS@partitionsBundle"/>
              </uix:rowLayout>

<uix:spacer height="5"/>

<uix:rowLayout width="80%">
              <uix:cellFormat hAlign="right" vAlign="top">

<uix:messagePrompt promptBinding="PCOL@partitionsBundle" labeledNodeId="PCOL"/>
                <uix:spacer width="5"/>
                <oem:choice name="pcol"
                            id="PCOL"
                            shortDescBinding="PCOL@partitionsBundle"
                            optionsBinding="pcols@partitionColsBean@servletRequest" 
                            disabledBinding="partsDisabled@dataPartitionsBean@servletRequest" />

<uix:spacer width="10"/>
                <uix:submitButton textBinding="ADD@partitionsBundle" 
                                  shortDescBinding="ADD@partitionsBundle"
                                  name="event" 
                                  disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                                  value="addFirst"/>
              </uix:cellFormat>
              </uix:rowLayout>
             </uix:stackLayout>

</uix:case>

<%-- CASE: No columns left to add --%>
            <uix:case name="false">
              <uix:stackLayout>
                <uix:rowLayout width="80%">
                  <uix:styledText styleClass="OraInstructionText"
                                  textBinding="GRCOLSDESC@partitionsBundle"/>
                </uix:rowLayout>
                <uix:spacer height="5"/>
              </uix:stackLayout>
            </uix:case>
          </uix:switcher>

<oem:table name="partitionColsUI" 
                     beanKey="partitionColsBean" 
                     formSubmitted="true" 
                     dataSourceProp="partitionColsUI" 
                     blockSize="10" 
                     width="80%"
                     summaryBinding="PCOLS@partitionsBundle"
                     alternateTextBinding="NO_PCOLS@partitionsBundle">

<uix:footer>
              <uix:submitButton textBinding="REMOVE@partitionsBundle" 
                                shortDescBinding="REMOVE@partitionsBundle"
                                name="event" 
                                renderedBinding="haveCol@partitionColsBean@servletRequest"
                                disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                                value="delLPCol"/>

</uix:footer>
          </oem:table> 
          <uix:tip>         
            <uix:styledText textBinding="PREFIX_TIP@msgs"
                            styleClass="OraTipText"/>
          </uix:tip>
        </uix:header>

</uix:cellFormat>
       </uix:rowLayout>

</uix:stackLayout>
     </uix:case>

<%-- CASE: Edit partitions --%>
     <uix:case name="false">
     <uix:stackLayout>
       <uix:spacer height="10"/>
       <uix:labeledFieldLayout labelWidth="20%">
         <uix:messagePrompt promptBinding="PMETHOD@partitionsBundle"/>
         <uix:styledText styleClass="OraDataText" 
                         textBinding="displayType@dataPartitionsBean@servletRequest" />
         <uix:messagePrompt promptBinding="PCOLS@partitionsBundle"/>
         <uix:styledText styleClass="OraDataText" 
                         textBinding="pcolsList@partitionColsBean@servletRequest" />
       </uix:labeledFieldLayout>
     </uix:stackLayout>
     </uix:case>

</uix:switcher>

<uix:spacer height="1"/>        
   
    <%-- Indent --%>   
    <uix:rowLayout width="100%">
      <uix:cellFormat> 
        <uix:spacer height="1" width="20" />
      </uix:cellFormat>
      <uix:cellFormat hAlign="right">

<%-- start : header --%>
    <uix:header textBinding="PARTS@partitionsBundle">
      <uix:spacer height="5"/>
      <%-- SWITCH: Create partitions --%>
      <uix:switcher childNameBinding="creating@objectBean@servletRequest">

<%-- CASE: Create partitions --%>
        <uix:case name="true">
    <uix:stackLayout>
      <uix:rowLayout>    
        <uix:styledText styleClass="OraInstructionText"
                        textBinding="RHVDESC@partitionsBundle"/>
      </uix:rowLayout>

<uix:spacer height="1"/>

<uix:rowLayout width="100%">
              <uix:cellFormat hAlign="right" width="100%">

<uix:messageTextInput name="numParts" 
                                  promptBinding="NUMPARTS@partitionsBundle"
                                  shortDescBinding="NUMPARTS@partitionsBundle"
                 textBinding="numParts@dataPartitionsBean@servletRequest"
                 disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                 columns="3">
              <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater>
            </uix:messageTextInput>
              </uix:cellFormat>
<uix:spacer width="10"/>
              <uix:cellFormat>

<uix:messageLovField name="tablespaceList"
                                         promptBinding="STOREIN@partitionsBundle"
                                         textBinding="tablespaceList@dataPartitionsBean@servletRequest"
                                         disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                                         columns="50"
                                         shortDescBinding="SELECT_TS@msgs"
                                         searchDescBinding="SELECT_TS@msgs"
                                         tipBinding="TSTIP@partitionsBundle"
                                         onClick = "appendData();selectMultiple();startLov('tablespaceList', 'ListTablespacePerm')"/>

<%--
                                         onClickBinding="grtblspclistlovdest@servletRequest" />
--%>

</uix:cellFormat>

<uix:spacer width="5"/>
              <uix:cellFormat>

<uix:submitButton textBinding="ADD@partitionsBundle" 
                                  shortDescBinding="ADD@partitionsBundle" 
                                  name="event" 
                                  disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                                  value="addPartitions"/>
              </uix:cellFormat>
            </uix:rowLayout>

<%-- GLOBAL TABLE BUTTONS --%>
      <uix:rowLayout width="100%">

<%-- SWITCH: Delete all partitions --%>
        <uix:switcher childNameBinding="haveParts@dataPartitionsBean@servletRequest">
          <%-- CASE: Have at least 1 partition --%>
          <uix:case name="true">
            <uix:cellFormat hAlign="right" vAlign="top" width="100%">
              <uix:submitButton textBinding="DELETEAP@partitionsBundle" 
                                shortDescBinding="DELETEAP@partitionsBundle" 
                                name="event" 
                                disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                                value="deleteAllPartitions"/>
            </uix:cellFormat>
          </uix:case>
        </uix:switcher>
      </uix:rowLayout>

</uix:stackLayout>
    </uix:case>

<%-- CASE: Edit partitions --%>
    <uix:case name="false">
       <uix:stackLayout>

<%-- Search Prompt --%>
         <uix:stackLayout renderedBinding="canSearch@dataPartitionsBean@servletRequest" >

<uix:rowLayout>
             <uix:styledText styleClass="OraInstructionText" textBinding="SEARCHPNAME@msgs" labeledNodeId="SEARCHPNAME"/>
             <uix:spacer height="1" width="5"/>
             <uix:textInput name="searchPartName" textBinding="searchPartName@dataPartitionsBean@servletRequest" columns="32" id="SEARCHPNAME" shortDescBinding="SEARCHPNAME@msgs"/>
             <uix:spacer height="1" width="5"/>
             <uix:submitButton textBinding="GO@msgs" name="event" value="searchPartitions" shortDescBinding="GO@msgs"/>
           </uix:rowLayout>
         </uix:stackLayout>
         <%-- End Search Prompt --%>

<uix:rowLayout>
           <uix:spacer height="5"/>
         </uix:rowLayout>
         <%-- End Search Prompt --%>

<%-- SWITCH: New partitions added during edit? --%>
         <uix:switcher childNameBinding="newPartitions@dataPartitionsBean@servletRequest">
           <%-- CASE: New partitions were added --%>
           <uix:case name="true">
             <uix:stackLayout>
               <uix:rowLayout>    
                 <uix:styledText styleClass="OraInstructionText"
                                 textBinding="RHVDESC@partitionsBundle"/>
               </uix:rowLayout>

<uix:spacer height="1"/>
             </uix:stackLayout>
           </uix:case>     
         </uix:switcher>   
       </uix:stackLayout>
     </uix:case>     
   </uix:switcher>

<oem:table name="dataPartitionsUI" 
                 beanKey="dataPartitionsBean" 
                 formSubmitted="true" 
                 dataSourceProp="dataPartitionsUI" 
                 blockSize="10" 
                 width="100%"
                 summaryBinding="PARTS@partitionsBundle"
                 alternateTextBinding="NO_PARTS@partitionsBundle">

<uix:tableSelection>
          <oem:singleSelection shortDescBinding="SELECT@uixDBObjectBundle@servletRequest"
               selectedIndexBinding="selectedIndex@dataPartitionsBean@servletRequest">
          <uix:flowLayout>

<%-- SWITCH: Create partitions --%>
            <uix:switcher childNameBinding="creating@objectBean@servletRequest">
              <%-- CASE: Create partitions --%>
              <uix:case name="true">
                <uix:flowLayout>
                  <uix:submitButton textBinding="ADVOPT@partitionsBundle" 
                                    shortDescBinding="ADVOPT@partitionsBundle" 
                                    name="event" 
                                    disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                                    value="advOptions"/>

<uix:spacer width="5"/>
                  <uix:submitButton textBinding="INSERT@partitionsBundle" 
                                    shortDescBinding="INSERT@partitionsBundle" 
                                    name="event" 
                                    disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                                    value="insertPartition"/>
                  <uix:spacer width="5"/>
                  <uix:submitButton textBinding="DELETE@partitionsBundle" 
                                    shortDescBinding="DELETE@partitionsBundle" 
                                    name="event" 
                                    disabledBinding="partsDisabled@dataPartitionsBean@servletRequest"
                                    value="deletePartition"/>
                </uix:flowLayout>
              </uix:case>

<%-- CASE: Edit partitions --%>
              <uix:case name="false">
                <uix:flowLayout>
                  <uix:submitButton textBinding="ADVOPT@partitionsBundle" 
                                    shortDescBinding="ADVOPT@partitionsBundle" 
                                    name="event" 
                                    value="advOptions"/>
                  <uix:spacer width="5"/>
                  <uix:submitButton textBinding="DELETE@partitionsBundle" 
                                    shortDescBinding="DELETE@partitionsBundle" 
                                    name="event" 
                                    value="deletePartition"/>

<uix:spacer width="10"/>
                  <uix:messagePrompt promptBinding="ACTIONS@partitionsBundle" labeledNodeId="ACTIONS"/>
                  <uix:spacer width="5"/>
                  <uix:choice name="actionChoice" id="ACTIONS"
                              selectedValueBinding="selectedAction@dataPartitionsBean@servletRequest">
                    <uix:option textBinding="RENAME@partitionsBundle" value="3" />
                    <uix:option textBinding="REBUILDPART@partitionsBundle" value="4" />
                    <uix:option textBinding="SPLIT@partitionsBundle" value="2" />
                    <uix:option textBinding="COALESCE@partitionsBundle" value="13" />
                  </uix:choice>  
                  <uix:spacer width="5"/>
                  <uix:submitButton textBinding="GO@partitionsBundle" 
                                    shortDescBinding="GO@partitionsBundle" 
                                    name="event" 
                                    value="selectAction" />       
               </uix:flowLayout>
              </uix:case>
            </uix:switcher>
 
          </uix:flowLayout>
          </oem:singleSelection>
        </uix:tableSelection>
      </oem:table>

<uix:switcher childNameBinding="newPartitions@dataPartitionsBean@servletRequest">
        <uix:case name="true">
          <uix:tip renderedBinding="hasDate@partitionColsBean@servletRequest">
            <uix:styledText textBinding="dateExample@dataPartitionsBean@servletRequest"
                            styleClass="OraTipText"/>
          </uix:tip>
        </uix:case>
      </uix:switcher>

<uix:spacer height="10"/>

</uix:header>
    </uix:cellFormat>
    </uix:rowLayout>

<%-- END: TAB CONTENTS ends here --%>

</uix:buildTree>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de