Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\schema\utilities\storageContextInclude.jsp
<%-- Name: storageContextInclude.jsp -- Type: JSP Include -- Description: This page contains the complete UI for storage for a -- schema object. -- -- EMO Beans: You provide the name of your instance of the -- SchemaObjectSegment bean as context to this include. -- Your controller must also add uixDBObjectBundle onto the -- request so messages can be retrieved correctly. Errors are expected -- to be in: errors@servletRequest -- -- JSP Changes: To use this page, add the following to your jsp file: -- -- <uix:dataScope currentDataBinding="<your segment bean>@servletRequest"> -- <jsp:include page="/database/schema/utilities/storageContextInclude.jsp" /> -- <uix:ref refID="storageInclude" /> -- </uix:dataScope> -- -- Controller Changes: -- Make your controller instaniate the emo beans listed -- above. The name of the bean can be whatever you need. -- Make sure your controller calls beanUtils with your bean -- when submit form is called. -- -- Initializer Changes: -- You must create a SegmentInitializer that extents from -- SchemaObjectSegmentInitializer - see Table for an example. -- -- Getting Storage To Initialize on CREATE: -- Currently you must override SchemaObjectSegment.java and then -- override the getInitializer function to save your own -- initializer. -- See TableSegment.java for an example. -- To make the page initialize everytime a tablespace changes, -- you must set the objects initialized variable to false -- whenever the tablespace changes. --%> <%@ taglib uri="http://xmlns.oracle.com/uix/ui" prefix="uix" %> <%@ taglib uri="http://xmlns.oracle.com/oem/jsp/tag" prefix="oem" %> <%@ page import="oracle.sysman.emo.adm.schema.SchemaObjectSegment" %> <script language="javascript"> function lovCallBack(returnValue) { if (returnValue != null) { lovTarget = callBackLovField(); document.forms[0][lovTarget].value = returnValue; submitForm(document.forms[0], true, {'event':'<%= SchemaObjectSegment.CHANGE_TABLESPACE %>'}); } } </script> <%-- STORAGE PAGE CONTENT --%> <uix:buildTree nodeID="storageInclude"> <uix:dataScope> <%-- Message Bundles Used --%> <uix:bundle name="dbMsgs" class="oracle.sysman.db.rsc.DBObjectMsg"/> <%-- Layout --%> <uix:tableLayout> <%-- Tip & Tablespace --%> <uix:rowLayout> <uix:tableLayout cellSpacing="5" width="100%"> <%-- Tip --%> <uix:rowLayout> <uix:cellFormat> <uix:tip> <uix:styledText styleClass="OraTipText" textBinding="STORAGE_TIP@dbMsgs" /> </uix:tip> </uix:cellFormat> </uix:rowLayout> <%-- START: Tablespace Information --%> <uix:rowLayout> <uix:cellFormat> <uix:header textBinding="TABLESPACE@dbMsgs"> <uix:labeledFieldLayout columns="1"> <%-- Tablespace Name : Note : using renderedBinding and not switcher due to layout problem --%> <%-- IF : changing the tblspace is allowed --%> <%-- Tablespace LOV w/ Change Button --%> <uix:messagePrompt promptBinding="NAME@dbMsgs" labeledNodeId="TABLESPACE_ID" renderedBinding="changeTablespaceAvail@"/> <uix:tableLayout renderedBinding="changeTablespaceAvail@"> <uix:rowLayout> <uix:messageLovField name="<%= SchemaObjectSegment.CHANGE_TABLESPACE %>" id="TABLESPACE_ID" textBinding="realTablespace@" searchDescBinding="CLICKTOSELECTTABLESPACE@dbMsgs" shortDescBinding="CLICKTOSELECTTABLESPACE@dbMsgs" onClick = "useCallBack();startLov('changeTablespace','ListTablespaceAll')" disabledBinding="allDisabled@"/> <uix:submitButton textBinding="REFRESHTS@dbMsgs" id="TABLESPACE_ID" shortDescBinding="REFRESHTS@dbMsgs" name="event" value="<%= SchemaObjectSegment.CHANGE_TABLESPACE %>" renderedBinding="new@"/> </uix:rowLayout> </uix:tableLayout> <%-- ELSE IF : tablespace name is read only and can't be changed --%> <%-- Tablespace Name : Read Only Text --%> <uix:messageStyledText promptBinding="NAME@dbMsgs" shortDescBinding="NAME@dbMsgs" textBinding="realTablespace@" contentStyleClass="OraDataText" renderedBinding="tablespaceReadOnly@"/> <%-- Tablespace Extent Management --%> <uix:switcher childNameBinding="locallyManaged@"> <uix:case name="true"> <uix:messageStyledText promptBinding="EXTENT_MGMT@dbMsgs" shortDescBinding="EXTENT_MGMT@dbMsgs" textBinding="LOCAL@dbMsgs" contentStyleClass="OraDataText"/> </uix:case> <uix:case name="false"> <uix:messageStyledText promptBinding="EXTENT_MGMT@dbMsgs" shortDescBinding="EXTENT_MGMT@dbMsgs" textBinding="DICTIONARY@dbMsgs" contentStyleClass="OraDataText"/> </uix:case> </uix:switcher> <%-- Tablespace Segment Management --%> <uix:messageStyledText promptBinding="SEGMENT_MANAGEMENT@dbMsgs" shortDescBinding="SEGMENT_MANAGEMENT@dbMsgs" textBinding="segmentMgmt@" contentStyleClass="OraDataText"/> <%-- Allocation Type --%> <uix:messageStyledText promptBinding="ALLOCATION_TYPE@dbMsgs" shortDescBinding="ALLOCATION_TYPE@dbMsgs" textBinding="allocationType@" contentStyleClass="OraDataText"/> <%-- Logging --%> <uix:messageChoice name="loggingOpt" promptBinding="LOGGING@dbMsgs" shortDescBinding="LOGGING@dbMsgs" selectedValueBinding="loggingOpt@" disabledBinding="loggingDisabled@" > <uix:option textBinding="DEFAULT_OPT@dbMsgs" value="-1" /> <uix:option textBinding="YES@dbMsgs" value="1" /> <uix:option textBinding="NO@dbMsgs" value="0" /> </uix:messageChoice> </uix:labeledFieldLayout> </uix:header> </uix:cellFormat> </uix:rowLayout> <%-- END: Tablespace Information --%> </uix:tableLayout> </uix:rowLayout> <%-- Storage Data --%> <uix:rowLayout> <uix:tableLayout cellSpacing="5" width="100%"> <%-- START: Dictionary Extent Management --%> <%-- For Dictionary Managed tablespaces, all extent management --%> <%-- is displayed all storage info in one table row which starts here --%> <uix:rowLayout> <uix:cellFormat vAlign="top" renderedBinding="showExtentAttributes@"> <uix:header textBinding="EXTENTS@dbMsgs"> <uix:tableLayout cellSpacing="5" > <%-- Inital Size --%> <uix:rowLayout> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="INITIAL_SIZE@dbMsgs" labeledNodeId="INITIAL_SIZE"/> </uix:cellFormat> <uix:stackLayout> <uix:flowLayout> <uix:textInput name="initExtentSize" id="INITIAL_SIZE" shortDescBinding="INITIAL_SIZE@dbMsgs" textBinding="initExtentSize@" columns="10" disabledBinding="disabled@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> <oem:choice name="initExtentSizeUnit" shortDescBinding="INITIAL_SIZE@dbMsgs" optionsBinding="sizeUnitChoices@" selectedValueBinding="initExtentSizeUnit@" disabledBinding="disabled@"/> </uix:flowLayout> <uix:messageText messageType="error" messageBinding="initExtentSize@errors@servletRequest" /> </uix:stackLayout> </uix:rowLayout> <%-- Next Size --%> <uix:rowLayout> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="NEXT_SIZE@dbMsgs" labeledNodeId="NEXT_SIZE"/> </uix:cellFormat> <uix:stackLayout> <uix:flowLayout> <uix:textInput name="nextExtentSize" id="NEXT_SIZE" shortDescBinding="NEXT_SIZE@dbMsgs" textBinding="nextExtentSize@" columns="10" disabledBinding="disabledByType@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> <oem:choice name="nextExtentSizeUnit" shortDescBinding="NEXT_SIZE@dbMsgs" optionsBinding="sizeUnitChoices@" selectedValueBinding="nextExtentSizeUnit@" disabledBinding="disabledByType@"/> </uix:flowLayout> <uix:messageText messageType="error" messageBinding="nextExtentSize@errors@servletRequest" /> </uix:stackLayout> </uix:rowLayout> <%-- Increment Size --%> <uix:rowLayout vAlign="top" renderedBinding="showExtentAttributes@"> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="INCREMENT_SIZE@dbMsgs" labeledNodeId="INCREMENT_SIZE"/> </uix:cellFormat> <uix:cellFormat> <uix:stackLayout> <uix:textInput name="pctIncrease" id="INCREMENT_SIZE" shortDescBinding="INCREMENT_SIZE@dbMsgs" textBinding="pctIncrease@" columns="10" disabledBinding="disabledByType@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> <uix:messageText messageType="error" messageBinding="pctIncrease@errors@servletRequest" /> </uix:stackLayout> </uix:cellFormat> </uix:rowLayout> <%-- Minimum Number --%> <uix:rowLayout vAlign="top" renderedBinding="showExtentAttributes@"> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="MINIMUM_NUMBER@dbMsgs" labeledNodeId="MINIMUM_NUMBER"/> </uix:cellFormat> <uix:stackLayout> <uix:textInput name="minExtents" id="MINIMUM_NUMBER" shortDescBinding="MINIMUM_NUMBER@dbMsgs" textBinding="minExtents@" columns="10" disabledBinding="disabledByType@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> <uix:messageText messageType="error" messageBinding="minExtents@errors@servletRequest" /> </uix:stackLayout> </uix:rowLayout> <%-- Maximum Number --%> <uix:rowLayout vAlign="top" renderedBinding="showExtentAttributes@"> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="MAXIMUM_NUMBER@dbMsgs"/> </uix:cellFormat> <uix:stackLayout> <oem:radioButton name="unlimitedMaxExtents" value="true" textBinding="UNLIMITED@dbMsgs" shortDescBinding="UNLIMITED@dbMsgs" selectedValueBinding="unlimitedMaxExtents@" disabledBinding="disabledByType@"/> <uix:flowLayout> <oem:radioButton name="unlimitedMaxExtents" value="false" textBinding="VALUE@dbMsgs" shortDescBinding="VALUE@dbMsgs" selectedValueBinding="unlimitedMaxExtents@" disabledBinding="disabledByType@"/> <uix:textInput name="maxExtents" shortDescBinding="MAXIMUM_NUMBER@dbMsgs" textBinding="maxExtents@" columns="11" disabledBinding="disabledByType@"/> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:flowLayout> </uix:stackLayout> <uix:messageText messageType="error" messageBinding="maxExtents@errors@servletRequest" /> </uix:rowLayout> </uix:tableLayout> </uix:header> </uix:cellFormat> <%-- END: Dictionary Extent Management --%> <%-- START: Segment Storage and Locally Managed Initial Extent--%> <uix:cellFormat vAlign="top"> <uix:tableLayout> <%-- Locally Managed: Initial Size --%> <uix:switcher childNameBinding="showExtentAttributes@"> <uix:case name="false"> <uix:rowLayout> <uix:cellFormat vAlign="top"> <uix:header textBinding="EXTENTS@dbMsgs"> <uix:tableLayout cellSpacing="5"> <uix:rowLayout> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="INITIAL_SIZE@dbMsgs" labeledNodeId="INITIAL_SIZE"/> </uix:cellFormat> <uix:stackLayout> <uix:flowLayout> <uix:textInput name="initExtentSize" id="INITIAL_SIZE" shortDescBinding="INITIAL_SIZE@dbMsgs" textBinding="initExtentSize@" columns="10" disabledBinding="disabled@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> <oem:choice name="initExtentSizeUnit" shortDescBinding="INITIAL_SIZE@dbMsgs" optionsBinding="sizeUnitChoices@" selectedValueBinding="initExtentSizeUnit@" disabledBinding="disabled@"/> </uix:flowLayout> <uix:messageText messageType="error" messageBinding="initExtentSize@errors@servletRequest" /> </uix:stackLayout> </uix:rowLayout> </uix:tableLayout> </uix:header> </uix:cellFormat> </uix:rowLayout> </uix:case> </uix:switcher> <%-- START: Segment Storage --%> <uix:rowLayout> <%-- Space Usage --%> <uix:cellFormat vAlign="top" renderedBinding="extAttrsAvailable@"> <%-- switcher for Spatial Column --%> <%-- <uix:switcher childNameBinding="spatial@indexColumnBean@servletRequest"> --%> <%-- <uix:case name="false"> --%> <uix:header textBinding="SPACE_USAGE@dbMsgs"> <uix:tableLayout cellSpacing="5"> <uix:rowLayout> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="FREE_SPACE_PCT@dbMsgs" labeledNodeId="FREE_SPACE_PCT"/> </uix:cellFormat> <uix:textInput name="pctFree" id="FREE_SPACE_PCT" shortDescBinding="FREE_SPACE_PCT@dbMsgs" textBinding="pctFree@" columns="10" disabledBinding="pctFreeDisabled@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> </uix:rowLayout> <uix:rowLayout renderedBinding="pctUsedAvailable@"> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="USED_SPACE_PCT@dbMsgs" labeledNodeId="USED_SPACE_PCT"/> </uix:cellFormat> <uix:textInput name="pctUsed" id="USED_SPACE_PCT" shortDescBinding="USED_SPACE_PCT@dbMsgs" textBinding="pctUsed@" columns="10" disabledBinding="allDisabled@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> </uix:rowLayout> </uix:tableLayout> </uix:header> <%-- </uix:case> end for switcher case --%> <%-- </uix:switcher> --%> <%-- End of switcher to check if it is of type spatial --%> </uix:cellFormat> <%-- Free Lists --%> <uix:cellFormat vAlign="top" renderedBinding="freeListAvailable@"> <%-- switcher for Spatial Column --%> <%-- <uix:switcher childNameBinding="spatial@indexColumnBean@servletRequest"> <uix:case name="false"> --%> <uix:stackLayout> <uix:header textBinding="FREE_LISTS@dbMsgs"> <uix:tableLayout cellSpacing="5"> <uix:rowLayout> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="FREE_LISTS@dbMsgs" labeledNodeId="FREE_LISTS"/> </uix:cellFormat> <uix:switcher childNameBinding="versionEqualOrHigher81@"> <uix:case name="true"> <uix:textInput name="freeLists" id="FREE_LISTS" shortDescBinding="FREE_LISTS@dbMsgs" textBinding="freeLists@" columns="10" disabledBinding="disabledByType@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> </uix:case> <uix:case name="false"> <uix:textInput name="freeLists" id="FREE_LISTS" shortDescBinding="FREE_LISTS@dbMsgs" textBinding="freeLists@" columns="10" disabledBinding="disabled@" > <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> </uix:case> </uix:switcher> </uix:rowLayout> <uix:rowLayout> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="FREE_LIST_GROUPS@dbMsgs" labeledNodeId="FREE_LIST_GROUPS"/> </uix:cellFormat> <uix:textInput name="freeListGroups" id="FREE_LIST_GROUPS" shortDescBinding="FREE_LIST_GROUPS@dbMsgs" textBinding="freeListGroups@" columns="10" disabledBinding="disabled@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> </uix:rowLayout> </uix:tableLayout> </uix:header> </uix:stackLayout> <%-- </uix:case> end for switcher case --%> <%-- </uix:switcher> --%> <%-- End of switcher to check if it is of type spatial --%> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout> <%-- Number of Transactions --%> <uix:cellFormat vAlign="top" renderedBinding="extAttrsAvailable@"> <%-- switcher for Spatial Column --%> <%-- <uix:switcher childNameBinding="spatial@indexColumnBean@servletRequest"> --%> <%-- <uix:case name="false"> --%> <uix:header textBinding="NUM_OF_TRAN@dbMsgs"> <uix:tableLayout cellSpacing="5"> <uix:rowLayout> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="INITIAL@dbMsgs" labeledNodeId="INITIAL"/> </uix:cellFormat> <uix:textInput name="iniTrans" id="INITIAL" shortDescBinding="INITIAL@dbMsgs" textBinding="iniTrans@" columns="10" disabledBinding="disabledByType@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> </uix:rowLayout> <uix:rowLayout> <uix:messagePrompt promptBinding="MAXIMUM@dbMsgs" labeledNodeId="MAXIMUM"/> <uix:textInput name="maxTrans" id="MAXIMUM" shortDescBinding="MAXIMUM@dbMsgs" textBinding="maxTrans@" columns="10" disabledBinding="disabledByType@"> <uix:onSubmitValidater><uix:decimal /></uix:onSubmitValidater> </uix:textInput> </uix:rowLayout> </uix:tableLayout> </uix:header> <%-- </uix:case> end for switcher case --%> <%-- </uix:switcher> --%> <%-- End of switcher to check if it is of type spatial --%> </uix:cellFormat> <%-- Buffer Pool --%> <uix:cellFormat vAlign="top"> <%-- switcher for Spatial Column --%> <%-- <uix:switcher childNameBinding="spatial@indexColumnBean@servletRequest"> --%> <%-- <uix:case name="false"> --%> <uix:header textBinding="BUFFER_POOL@dbMsgs"> <uix:tableLayout cellSpacing="5"> <uix:rowLayout> <uix:cellFormat hAlign="right"> <uix:messagePrompt promptBinding="BUFFER_POOL@dbMsgs" labeledNodeId="BUFFER_POOL"/> </uix:cellFormat> <uix:cellFormat> <oem:choice name="bufferPool" id="BUFFER_POOL" shortDescBinding="BUFFER_POOL@dbMsgs" selectedValueBinding="bufferPool@" disabledBinding="allDisabled@" optionsBinding="bufferPoolChoices@"/> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:header> <%-- </uix:case> --%> <%-- </uix:switcher> --%> <%-- End of switcher to check if it is of type spatial --%> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:rowLayout> <%-- END: Segment Storage --%> </uix:tableLayout> </uix:dataScope> </uix:buildTree>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de