Edit D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\xml\schema\kusindxt.xsd

<?xml version="1.0"?>
<!--

NAME
    kusindxt.xsd
DESCRIPTION
    XML Schema types for INDEX SXML.

MODIFIED        MM/DD/YY
    lbarton     09/12/08 - bug 7362930: UNUSABLE index (sub)partitions
    lbarton     06/18/08 - bug 7188926: parameters in partitioned domain index
    lbarton     08/14/07 - column expressions
    lbarton     01/17/08 - Bug 6724820: table compression
    lbarton     12/19/07 - Bug 6655531: customer area
    rapayne     01/09/07 - Allow UNUSABLE and MONITORING_USAGE 
    rapayne     12/28/06 - allow PARALLEL and PARALLEL_DEGREE
    rapayne     12/13/06 - allow 'src' attribs for COL_LIST_ITEM
    lbarton     11/15/06 - diff support
    sdavidso    04/25/06 - Add INVISIBLE index attribute tag 
    sdavidso    05/02/06 - fix parameters for domain index
    lbarton     11/09/05 - Bug 4724986: reformat files for use with XMLSpy 
    lbarton     10/18/05 - lbarton_mddiff2
    lbarton     09/06/05 - Initial version
 -->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ku="http://xmlns.oracle.com/ku" targetNamespace="http://xmlns.oracle.com/ku" elementFormDefault="qualified" attributeFormDefault="unqualified">
 
 <xsd:include schemaLocation="kuscomm.xsd"/>
 <xsd:include schemaLocation="kusparse.xsd"/>
 
 <xsd:complexType name="INDEXType">
  <xsd:sequence>
   <xsd:element ref="ku:UnqBitmap" minOccurs="0"/>
   <xsd:group ref="ku:SCHEMA_NAMEGroup"/>
   <xsd:choice>
    <xsd:element name="CLUSTER_INDEX" type="ku:ClusterIndexClause"/>
    <xsd:element name="TABLE_INDEX" type="ku:TableIndexClause"/>
    <xsd:element name="BITMAP_JOIN_INDEX" type="ku:BitmapJoinIndexClause"/>
   </xsd:choice>
   <xsd:element name="CUSTOMER_AREA" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="version" type="ku:vsn" use="required"/>
  <xsd:attribute name="version2" type="ku:vsn"/>
  
 </xsd:complexType>
 
 <xsd:element name="UnqBitmap" type="ku:EmptyType" abstract="true"/>
 <xsd:element name="UNIQUE" type="ku:EmptyType" substitutionGroup="ku:UnqBitmap"/>
 <xsd:element name="BITMAP" type="ku:EmptyType" substitutionGroup="ku:UnqBitmap"/>
 <xsd:complexType name="ClusterIndexClause">
  <xsd:sequence>
   <xsd:element name="ON_CLUSTER" type="ku:SCHEMA_NAMEType"/>
   <xsd:element name="INDEX_ATTRIBUTES" type="ku:INDEX_ATTRIBUTESType" minOccurs="0"/>
   <xsd:element name="UNUSABLE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="MONITORING_USAGE" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="TableIndexClause">
  <xsd:sequence>
   <xsd:element name="ON_TABLE" type="ku:SCHEMA_NAMEType"/>
   <xsd:element name="COL_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="COL_LIST_ITEM" type="ku:IndexCOL_LIST_ITEMType" maxOccurs="1000"/>
     </xsd:sequence>
     <xsd:attribute name="src" type="ku:srcType"/>
    </xsd:complexType>
   </xsd:element>
   <xsd:group ref="ku:IndexProperties" minOccurs="0"/>
   <xsd:element name="UNUSABLE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="MONITORING_USAGE" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="IndexCOL_LIST_ITEMType">
  <xsd:sequence>
   <xsd:choice>
    <xsd:element name="NAME" type="ku:char4000ElementWithValue1"/>
    <xsd:element name="COLUMN_EXPRESSION" type="ku:PrsColExpressionType"/>
   </xsd:choice>
   <xsd:element name="DESC" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:group name="IndexProperties">
  <!-- *******************************************************************
 group: IndexProperties
  choice:

[ INDEX_ATTRIBUTES ]
    optional choice
      GLOBAL_PARTITIONING
      LOCAL_PARTITIONING

DOMAIN_INDEX_PROPERTIES
      INDEXTYPE
      etc.

******************************************************************** -->
  <xsd:choice>
   <xsd:sequence>
    <xsd:element name="INDEX_ATTRIBUTES" type="ku:INDEX_ATTRIBUTESType"/>
    <xsd:choice id="IndexPartitioning" minOccurs="0">
     <xsd:element name="GLOBAL_PARTITIONING" type="ku:GlobalPartitionedIndexType"/>
     <xsd:element name="LOCAL_PARTITIONING" type="ku:LocalPartitionedIndexType"/>
    </xsd:choice>
   </xsd:sequence>
   
   <xsd:sequence>
    <xsd:element name="DOMAIN_INDEX_PROPERTIES">
     <xsd:complexType>
      <xsd:sequence>
       <xsd:element name="INDEXTYPE">
        <xsd:complexType>
         <xsd:sequence>
          <xsd:element name="SCHEMA" type="ku:char30ElementWithValue1" minOccurs="0"/>
          <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
         </xsd:sequence>
        </xsd:complexType>
       </xsd:element>
       <xsd:choice minOccurs="0" maxOccurs="2">
        <xsd:element name="PARALLEL" type="ku:PARALLELTypeWithValue1"/>
        <xsd:element name="PARALLEL_DEGREE" type="ku:OldPARALLELType"/>
       </xsd:choice>
       <xsd:sequence>
        <xsd:element name="PARAMETERS" type="ku:char1000ElementWithValue1" minOccurs="0"/>
        <xsd:element name="LOCAL_PARTITIONING" type="ku:DomidxLocalPartitioningType" minOccurs="0"/>
       </xsd:sequence>
      </xsd:sequence>
     </xsd:complexType>
    </xsd:element>
   </xsd:sequence>
  </xsd:choice>
 </xsd:group>
 <xsd:complexType name="BitmapJoinIndexClause">
  <xsd:sequence>
   <xsd:element name="ON_TABLE" type="ku:SCHEMA_NAMEType"/>
   <xsd:element name="COL_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="COL_LIST_ITEM" type="ku:BJIndexCOL_LIST_ITEMType" maxOccurs="1000"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
   <xsd:element name="JOIN_TABLE_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="JOIN_TABLE_LIST_ITEM" type="ku:SCHEMA_NAMEType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
   <xsd:element name="WHERE_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="WHERE_LIST_ITEM" type="ku:WHERE_LIST_ITEMType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
   <xsd:element name="INDEX_ATTRIBUTES" type="ku:INDEX_ATTRIBUTESType" minOccurs="0"/>
   <xsd:element name="UNUSABLE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="MONITORING_USAGE" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="BJIndexCOL_LIST_ITEMType">
  <xsd:sequence>
   <xsd:element name="SCHEMA" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="COL" type="ku:char30ElementWithValue1"/>
   <xsd:element name="DESC" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="WHERE_LIST_ITEMType">
  <xsd:sequence>
   <xsd:element name="JOIN_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="JOIN_LIST_ITEM" minOccurs="2" maxOccurs="2">
       <xsd:complexType>
        <xsd:sequence>
         <xsd:group ref="ku:SCHEMA_NAMEGroup"/>
         <xsd:element name="COL" type="ku:char30ElementWithValue1"/>
        </xsd:sequence>
       </xsd:complexType>
      </xsd:element>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="INDEX_ATTRIBUTESType">
  <xsd:sequence>
   <xsd:element name="PCTFREE" type="ku:pctElementWithValue1" minOccurs="0"/>
   <xsd:element name="INITRANS" type="ku:int255ElementWithValue1" minOccurs="0"/>
   <xsd:element name="STORAGE" type="ku:STORAGEType" minOccurs="0"/>
   <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="LOGGING" type="ku:YNElementWithValue1" minOccurs="0"/>
   <xsd:element name="KEYCOMPRESS" type="ku:KeyCompressTypeWithValue1" minOccurs="0"/>
   <xsd:element name="REVERSE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="INVISIBLE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:choice minOccurs="0" maxOccurs="2">
    <xsd:element name="PARALLEL" type="ku:PARALLELTypeWithValue1"/>
    <xsd:element name="PARALLEL_DEGREE" type="ku:OldPARALLELType"/>
   </xsd:choice>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="GlobalPartitionedIndexType">
  <xsd:choice>
   <xsd:element name="RANGE_PARTITIONING" type="ku:IndexRangePartitioningType"/>
   <xsd:element name="HASH_PARTITIONING" type="ku:IndexHashPartitioningType"/>
  </xsd:choice>
  
 </xsd:complexType>
 <xsd:complexType name="IndexRangePartitioningType">
  <xsd:sequence>
   <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType"/>
   <xsd:element name="PARTITION_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="PARTITION_LIST_ITEM" type="ku:IndexRangePartitionClauseType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="IndexRangePartitionClauseType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:element name="VALUES" type="ku:char4000ElementWithValue1"/>
   <xsd:element name="SEGMENT_ATTRIBUTES" type="ku:SEGMENT_ATTRIBUTESType" minOccurs="0"/>
   <xsd:element name="KEYCOMPRESS" type="ku:KeyCompressTypeWithValue1" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="IndexHashPartitioningType">
  <xsd:sequence>
   <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType"/>
   <xsd:element name="PARTITION_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="PARTITION_LIST_ITEM" type="ku:IndexHashPartitionClauseType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="IndexHashPartitionClauseType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="LocalPartitionedIndexType">
  <xsd:sequence>
   <xsd:element name="PARTITION_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="PARTITION_LIST_ITEM" type="ku:IndexLocalPartitionClauseType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="IndexLocalPartitionClauseType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:choice minOccurs="0">
    <xsd:element name="SEGMENT_ATTRIBUTES" type="ku:SEGMENT_ATTRIBUTESType"/>
    
    <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1"/>
   </xsd:choice>
   <xsd:element name="KEYCOMPRESS" type="ku:KeyCompressTypeWithValue1" minOccurs="0"/>
   <xsd:element name="UNUSABLE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="SUBPARTITION_LIST" minOccurs="0">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="SUBPARTITION_LIST_ITEM" type="ku:IndexSubpartitionClauseType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="IndexSubpartitionClauseType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="UNUSABLE" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="DomidxLocalPartitioningType">
  <xsd:sequence>
   <xsd:element name="PARTITION_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="PARTITION_LIST_ITEM" type="ku:DomidxPARTITION_LIST_ITEMType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  <!-- *******************************************************************
     Domain index partitioning clauses

complexType for DomidxLocalPartitioning
    PARTITION_LIST - a list of PARTITION_LIST_ITEMS of type 
        DomidxPARTITION_LIST_ITEMType
         NAME
         PARAMETERS
******************************************************************** -->
 </xsd:complexType>
 <xsd:complexType name="DomidxPARTITION_LIST_ITEMType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:element name="PARAMETERS" type="ku:char1000ElementWithValue1" minOccurs="0"/>
  </xsd:sequence>
 </xsd:complexType>
</xsd:schema>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de