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

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

NAME
    kustablt.xsd
DESCRIPTION
    XML Schema types for TABLE SXML.

MODIFIED        MM/DD/YY
    lbarton     08/28/08 - xmltype virtual columns
    rapayne     04/04/08 - Move OIDType definitions to kuscomm.xsd
    ebatbout    02/19/08 - Bug 6075698: Add 1. segcol_num,intcol_num,
                           internal_name for column list item, 2. column list 
                           for XMLType table clause, and 3. more column info 
                           for object column properties (ie. char. semantics, 
                           precision/scale)
    lbarton     02/12/08 - reference/system partitioning
    lbarton     01/15/08 - Bug 6724820: table compression
    lbarton     01/18/08 - RETENTION/PCTVERSION
    lbarton     12/13/07 - Bug 6655531: customer area
    lbarton     12/12/07 - bug 6682373: char semantics
    slynn       02/25/07 - Backout changes that removed dedup validate.
    lbarton     11/15/06 - diff support
    slynn       11/20/06 - Remove unimplemented SECUREFILE keywords
    slynn       10/26/06 - smartfile->securefile
    lbarton     10/09/06 - interval partitioning
    rapayne     09/22/06 - bug 5548395 - Add support for hash_partitions_by_quantity
                         - bug 5548402 - Allow for optional (i.e., system generated) 
                           partition names.
    lbarton     08/29/06 - All composite partitioning combinations
    slynn       08/09/06 - LOCAL to SMARTFILE.
    slynn       07/31/06 - change csce keywords.
    jforsyth    05/10/06 - add LOBENCRYPT, SHARE, LOBCOMPRESS for LOBs 
    kkunchit    11/01/05 - project-18204: inode: LOCAL/NOLOCAL support 
    mbaloglu    03/13/06 - Project 18207: Add [A]SYNC for LOBs 
    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="kuscnstr.xsd"/>
 
 <xsd:complexType name="TABLEType">
  <xsd:sequence>
   <xsd:element name="GLOBAL_TEMPORARY" type="ku:EmptyType" minOccurs="0"/>
   <xsd:group ref="ku:SCHEMA_NAMEGroup"/>
   
   <xsd:choice maxOccurs="2">
    <xsd:element name="RELATIONAL_TABLE" type="ku:RelationalTableClause"/>
    <xsd:element name="OBJECT_TABLE" type="ku:ObjectTableClause"/>
    <xsd:element name="XMLTYPE_TABLE" type="ku:XMLTypeTableClause"/>
   </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:complexType name="RelationalTableClause">
  <xsd:sequence>
   <xsd:element name="COL_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="COL_LIST_ITEM" type="ku:TableCOL_LIST_ITEMType" maxOccurs="1000"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
   <xsd:group ref="ku:TableConstraintsGroup"/>
   <xsd:element name="SUPPLEMENTAL_LOGGING" type="ku:SUPPLEMENTAL_LOGGINGType" minOccurs="0"/>
   <xsd:element name="ON_COMMIT" type="ku:ON_COMMITTypeWithValue1" minOccurs="0"/>
   <xsd:element name="PHYSICAL_PROPERTIES" type="ku:PhysicalPropertiesType" minOccurs="0"/>
   <xsd:element name="TABLE_PROPERTIES" type="ku:TablePropertiesType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="TableCOL_LIST_ITEMType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:element name="DATATYPE" type="ku:TypeNameElementWithValue1"/>
   <xsd:element name="LENGTH" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="CHAR_SEMANTICS" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="PRECISION" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="SCALE" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="TYPE_PROPERTIES" type="ku:optSCHEMA_NAMEType" minOccurs="0"/>
   <xsd:element name="SORT" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="VIRTUAL" type="ku:char4000ElementWithValue1" minOccurs="0"/>
   <xsd:element name="HIDDEN" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="DEFAULT" type="ku:char4000ElementWithValue1" minOccurs="0"/>
   <xsd:element name="NOT_NULL" type="ku:NOT_NULLType" minOccurs="0"/>
   <xsd:element name="ENCRYPT" type="ku:ENCRYPTType" minOccurs="0"/>
   <xsd:element name="SEGCOL_NUM" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="INTCOL_NUM" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="INTERNAL_NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="CUSTOMER_AREA" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="NOT_NULLType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:group ref="ku:ConstraintStateEnable" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="ENCRYPTType">
  <xsd:sequence>
   <xsd:element name="USING" type="ku:char30ElementWithValue1"/>
   <xsd:element name="PASSWORD" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="NOSALT" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="SUPPLEMENTAL_LOGGINGType">
  <xsd:sequence>
   <xsd:element name="GROUP_LIST" type="ku:GROUP_LISTType" minOccurs="0"/>
   <xsd:element name="ID_LIST" type="ku:ID_LISTType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="GROUP_LISTType">
  <xsd:sequence>
   <xsd:element name="GROUP_LIST_ITEM" maxOccurs="unbounded">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
      <xsd:element name="COL_LIST">
       <xsd:complexType>
        <xsd:sequence>
         <xsd:element name="COL_LIST_ITEM" type="ku:GROUP_LIST_COL_LIST_ITEMType" maxOccurs="1000"/>
        </xsd:sequence>
       </xsd:complexType>
      </xsd:element>
      <xsd:element name="ALWAYS" type="ku:EmptyType" minOccurs="0"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="GROUP_LIST_COL_LIST_ITEMType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
   <xsd:element name="NOLOG" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="ID_LISTType">
  <xsd:sequence>
   <xsd:element name="ID_LIST_ITEM" maxOccurs="unbounded">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="COLUMNS" type="ku:id_columnsTypeWithValue1"/>
     </xsd:sequence>
     <xsd:attribute name="src" type="ku:srcType"/>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:simpleType name="id_columnsType">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="ALL"/>
   <xsd:enumeration value="PRIMARY_KEY"/>
   <xsd:enumeration value="UNIQUE"/>
   <xsd:enumeration value="FOREIGN_KEY"/>
  </xsd:restriction>
  
 </xsd:simpleType>
 <xsd:complexType name="id_columnsTypeWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:id_columnsType">
    <xsd:attribute name="value1" type="ku:id_columnsType"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
 <xsd:simpleType name="ON_COMMITType">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="DELETE"/>
   <xsd:enumeration value="PRESERVE"/>
  </xsd:restriction>
  
 </xsd:simpleType>
 <xsd:complexType name="ON_COMMITTypeWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:ON_COMMITType">
    <xsd:attribute name="value1" type="ku:ON_COMMITType"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
 <xsd:complexType name="PhysicalPropertiesType">
  <xsd:sequence>
   
   <xsd:choice maxOccurs="2">
    <xsd:element name="HEAP_TABLE" type="ku:HEAP_TABLEType"/>
    <xsd:element name="INDEX_ORGANIZED_TABLE" type="ku:INDEX_ORGANIZED_TABLEType"/>
    <xsd:element name="EXTERNAL_TABLE" type="ku:EXTERNAL_TABLEType"/>
    <xsd:element name="CLUSTER_TABLE" type="ku:CLUSTER_TABLEType"/>
   </xsd:choice>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="HEAP_TABLEType">
  <xsd:sequence>
   <xsd:element name="SEGMENT_ATTRIBUTES" type="ku:SEGMENT_ATTRIBUTESType" minOccurs="0"/>
   <xsd:element name="COMPRESS" type="ku:TableCompressTypeWithValue1" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="INDEX_ORGANIZED_TABLEType">
  <xsd:sequence>
   <xsd:element name="SEGMENT_ATTRIBUTES" type="ku:SEGMENT_ATTRIBUTESType" minOccurs="0"/>
   <xsd:element name="MAPPING_TABLE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="PCTTHRESHOLD" type="ku:pctElementWithValue1" minOccurs="0"/>
   <xsd:element name="KEYCOMPRESS" type="ku:KeyCompressTypeWithValue1" minOccurs="0"/>
   <xsd:element name="OVERFLOW" type="ku:OVERFLOWType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="OVERFLOWType">
  <xsd:sequence>
   <xsd:element name="INCLUDING" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="SEGMENT_ATTRIBUTES" type="ku:SEGMENT_ATTRIBUTESType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="EXTERNAL_TABLEType">
  <xsd:sequence>
   <xsd:element name="ACCESS_DRIVER_TYPE" type="ku:char30ElementWithValue1"/>
   <xsd:element name="DEFAULT_DIRECTORY" type="ku:char30ElementWithValue1"/>
   <xsd:element name="ACCESS_PARAMETERS" type="ku:stringElementWithValue1"/>
   <xsd:element name="LOCATION" type="ku:LOCATIONType"/>
   <xsd:element name="REJECT_LIMIT" type="ku:REJECT_LIMITTypeWithValue1" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:simpleType name="REJECT_LIMITType1">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="UNLIMITED"/>
  </xsd:restriction>
  
 </xsd:simpleType>
 <xsd:simpleType name="REJECT_LIMITType">
  <xsd:union memberTypes="ku:REJECT_LIMITType1 xsd:nonNegativeInteger"/>
 </xsd:simpleType>
 <xsd:complexType name="REJECT_LIMITTypeWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:REJECT_LIMITType">
    <xsd:attribute name="value1" type="ku:REJECT_LIMITType"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
 <xsd:complexType name="LOCATIONType">
  <xsd:sequence>
   <xsd:element name="LOCATION_ITEM" type="ku:LOCATION_ITEMType" maxOccurs="unbounded"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="LOCATION_ITEMType">
  <xsd:sequence>
   <xsd:element name="DIRECTORY" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
 </xsd:complexType>
 <xsd:complexType name="CLUSTER_TABLEType">
  <xsd:sequence>
   <xsd:group ref="ku:SCHEMA_NAMEGroup"/>
   <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="TablePropertiesType">
  <xsd:sequence>
   <xsd:element name="COLUMN_PROPERTIES" type="ku:COLUMN_PROPERTIESType" minOccurs="0"/>
   <xsd:element name="XMLTYPE_VIRTUAL_COLUMNS" type="ku:XMLTYPE_VIRTUAL_COLUMNSType" minOccurs="0"/>
   
   <xsd:choice id="TablePartitioning" minOccurs="0" maxOccurs="2">
    <xsd:element name="RANGE_PARTITIONING" type="ku:RANGE_PARTITIONINGType"/>
    <xsd:element name="HASH_PARTITIONING" type="ku:HASH_PARTITIONINGType"/>
    <xsd:element name="LIST_PARTITIONING" type="ku:LIST_PARTITIONINGType"/>
    <xsd:element name="REFERENCE_PARTITIONING" type="ku:REFERENCE_PARTITIONINGType"/>
    <xsd:element name="SYSTEM_PARTITIONING" type="ku:SYSTEM_PARTITIONINGType"/>
   </xsd:choice>
   
   <xsd:choice minOccurs="0" maxOccurs="2">
    <xsd:element name="CACHE" 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:choice>
   <xsd:element name="ROW_DEPENDENCIES" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="ROW_MOVEMENT" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="FLASHBACK_ARCHIVE" type="ku:char30ElementWithValue1" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="COLUMN_PROPERTIESType">
  <xsd:sequence>
   <xsd:element name="COL_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="COL_LIST_ITEM" type="ku:TableColPropsCOL_LIST_ITEMType" maxOccurs="1000"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="TableColPropsCOL_LIST_ITEMType">
  <xsd:sequence>
   
   <xsd:element name="NAME" type="ku:char4000ElementWithValue1"/>
   <xsd:element name="DATATYPE" type="ku:TypeNameElementWithValue1"/>
   <xsd:choice>
    <xsd:group ref="ku:SubstitutableColProperties"/>
    <xsd:group ref="ku:NestedTableColProperties"/>
    <xsd:group ref="ku:VarrayColProperties"/>
    <xsd:group ref="ku:LOB_Properties"/>
    <xsd:group ref="ku:XMLTypeColProperties"/>
   </xsd:choice>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
 </xsd:complexType>
 <xsd:group name="SubstitutableColProperties">
  
  <xsd:sequence>
   
   <xsd:choice maxOccurs="2">
    <xsd:element name="OF_TYPE" type="ku:char30ElementWithValue1"/>
    <xsd:element name="SUBSTITUTABLE" type="ku:YNElementWithValue1"/>
   </xsd:choice>
  </xsd:sequence>
 </xsd:group>
 <xsd:group name="NestedTableColProperties">
  
  <xsd:sequence>
   <xsd:element name="NESTED_TABLE_PROPERTIES">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="STORAGE_TABLE" type="ku:STORAGE_TABLEType"/>
      <xsd:element name="RETURN_AS" type="ku:RETURN_ASTypeWithValue1"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
 </xsd:group>
 <xsd:complexType name="STORAGE_TABLEType">
  <xsd:sequence>
   <xsd:group ref="ku:SCHEMA_NAMEGroup"/>
   <xsd:element name="PRIMARY_KEY_CONSTRAINT_LIST" type="ku:PRIMARY_KEY_CONSTRAINT_LISTType" minOccurs="0"/>
   <xsd:element name="PHYSICAL_PROPERTIES" type="ku:PhysicalPropertiesType" minOccurs="0"/>
   <xsd:element name="TABLE_PROPERTIES" type="ku:TablePropertiesType" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:simpleType name="RETURN_ASType">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="LOCATOR"/>
   <xsd:enumeration value="VALUE"/>
  </xsd:restriction>
  
 </xsd:simpleType>
 <xsd:complexType name="RETURN_ASTypeWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:RETURN_ASType">
    <xsd:attribute name="value1" type="ku:RETURN_ASType"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
 <xsd:group name="VarrayColProperties">
  
  <xsd:sequence>
   <xsd:element name="VARRAY_PROPERTIES">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:group ref="ku:SubstitutableColProperties" minOccurs="0"/>
      <xsd:element name="STORE_AS" type="ku:VarraySTORE_ASTypeWithValue1"/>
      <xsd:choice>
       <xsd:group ref="ku:NestedTableColProperties"/>
       <xsd:group ref="ku:LOB_Properties"/>
      </xsd:choice>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
 </xsd:group>
 <xsd:simpleType name="VarraySTORE_ASType">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="LOB"/>
   <xsd:enumeration value="TABLE"/>
  </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="VarraySTORE_ASTypeWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:VarraySTORE_ASType">
    <xsd:attribute name="value1" type="ku:VarraySTORE_ASType"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
  
 </xsd:complexType>
 <xsd:group name="LOB_Properties">
  
  <xsd:sequence>
   <xsd:element name="LOB_PROPERTIES">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="STORAGE_TABLE">
       <xsd:complexType>
        <xsd:sequence>
         <xsd:group ref="ku:SCHEMA_NAMEGroup" minOccurs="0"/>
         <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1" minOccurs="0"/>
         <xsd:element name="SECUREFILE" type="ku:EmptyType" minOccurs="0"/>
         <xsd:element name="STORAGE_IN_ROW" type="ku:EmptyType" minOccurs="0"/>
         <xsd:element name="STORAGE" type="ku:STORAGEType" minOccurs="0"/>
         <xsd:element name="CHUNK" type="ku:intElementWithValue1" minOccurs="0"/>
         <xsd:choice minOccurs="0" maxOccurs="2">
          <xsd:element name="PCTVERSION" type="ku:pctElementWithValue1"/>
          <xsd:sequence>
           <xsd:element name="RETENTION" type="ku:LobretentionTypeWithValue1"/>
           <xsd:element name="MINTIME" type="ku:intElementWithValue1" minOccurs="0"/>
          </xsd:sequence>
         </xsd:choice>
         
         <xsd:element name="CACHE" type="ku:LOBCACHEElementWithValue1" minOccurs="0"/>
         <xsd:element name="LOGGING" type="ku:YNElementWithValue1" minOccurs="0"/>
         <xsd:element name="LOBENCRYPT" type="ku:EmptyType" minOccurs="0"/>
         <xsd:element name="LOBCOMPRESS" type="ku:LOBCOMPRESSElementWithValue1" minOccurs="0"/>
         <xsd:element name="DEDUPLICATE" type="ku:LOBDEDUPLICATEElementWithValue1" minOccurs="0"/>
         <xsd:element name="VALIDATE" type="ku:YNElementWithValue1" minOccurs="0"/>
        </xsd:sequence>
       </xsd:complexType>
      </xsd:element>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
 </xsd:group>
 <xsd:simpleType name="LOBCACHEElement">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="Y"/>
   <xsd:enumeration value="N"/>
   <xsd:enumeration value="READS"/>
  </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="LOBCACHEElementWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:LOBCACHEElement">
    <xsd:attribute name="value1" type="ku:LOBCACHEElement"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
  
 </xsd:complexType>
 <xsd:simpleType name="LOBCOMPRESSElement">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="HIGH"/>
   <xsd:enumeration value="MEDIUM"/>
   <xsd:enumeration value="LOW"/>
   
  </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="LOBCOMPRESSElementWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:LOBCOMPRESSElement">
    <xsd:attribute name="value1" type="ku:LOBCOMPRESSElement"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
  
 </xsd:complexType>
 <xsd:simpleType name="LOBDEDUPLICATEElement">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="LOB"/>
   <xsd:enumeration value="OBJECT"/>
   
  </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="LOBDEDUPLICATEElementWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:LOBDEDUPLICATEElement">
    <xsd:attribute name="value1" type="ku:LOBDEDUPLICATEElement"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
  
 </xsd:complexType>
 <xsd:group name="XMLTypeColProperties">
  
  <xsd:sequence>
   <xsd:element name="XMLTYPE_PROPERTIES">
    <xsd:complexType>
     <xsd:group ref="ku:XMLTypeColProperties1"/>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
 </xsd:group>
 <xsd:group name="XMLTypeColProperties1">
  <xsd:sequence>
   <xsd:element name="XMLTYPE_STORAGE">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="STORE_AS" type="ku:XMLTypeSTORE_ASTypeWithValue1"/>
      <xsd:group ref="ku:LOB_Properties" minOccurs="0"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
   <xsd:element name="XMLSCHEMA" type="ku:stringElementWithValue1" minOccurs="0"/>
   <xsd:element name="ELEMENT" type="ku:stringElementWithValue1" minOccurs="0"/>
   <xsd:element name="ID" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="ALLOW_ANYSCHEMA" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="DISALLOW_NONSCHEMA" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="OUT_OF_LINE" type="ku:EmptyType" minOccurs="0"/>
  </xsd:sequence>
 </xsd:group>
 <xsd:simpleType name="XMLTypeSTORE_ASType">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="LOB"/>
   <xsd:enumeration value="BINARY_XML"/>
   <xsd:enumeration value="OBJECT_RELATIONAL"/>
  </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="XMLTypeSTORE_ASTypeWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:XMLTypeSTORE_ASType">
    <xsd:attribute name="value1" type="ku:XMLTypeSTORE_ASType"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
  
 </xsd:complexType>
 <xsd:complexType name="STORE_INType">
  <xsd:sequence>
   <xsd:element name="STORE_IN_ITEM" type="ku:char30ElementWithValue1" maxOccurs="unbounded"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="RANGE_PARTITIONINGType">
  <xsd:sequence>
   <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType"/>
   <xsd:element name="DEFAULT_PHYSICAL_PROPERTIES" type="ku:DEFAULT_PHYSICAL_PROPERTIESType" minOccurs="0"/>
   <xsd:element name="INTERVAL" type="ku:char4000ElementWithValue1" minOccurs="0"/>
   <xsd:element name="STORE_IN" type="ku:STORE_INType" minOccurs="0"/>
   
   <xsd:choice minOccurs="0">
    <xsd:element name="HASH_SUBPARTITIONING" type="ku:SUBPARTITIONINGType"/>
    <xsd:element name="LIST_SUBPARTITIONING" type="ku:SUBPARTITIONINGType"/>
    <xsd:element name="RANGE_SUBPARTITIONING" type="ku:SUBPARTITIONINGType"/>
   </xsd:choice>
   <xsd:element name="PARTITION_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="PARTITION_LIST_ITEM" type="ku:TableRangeListPartitionClauseType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="DEFAULT_PHYSICAL_PROPERTIESType">
  <xsd:sequence>
   <xsd:choice>
    <xsd:element name="HEAP_TABLE" type="ku:HEAP_TABLEType"/>
    <xsd:element name="INDEX_ORGANIZED_TABLE" type="ku:INDEX_ORGANIZED_TABLEType"/>
   </xsd:choice>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="TableRangeListPartitionClauseType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="VALUES" type="ku:char4000ElementWithValue1"/>
   <xsd:element name="PHYSICAL_PROPERTIES" type="ku:DEFAULT_PHYSICAL_PROPERTIESType" minOccurs="0"/>
   
   <xsd:element name="COLUMN_PROPERTIES" type="ku:COLUMN_PROPERTIESType" minOccurs="0"/>
   <xsd:element name="SUBPARTITION_LIST" type="ku:SUBPARTITION_LISTType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="SUBPARTITION_LISTType">
  <xsd:sequence>
   <xsd:element name="SUBPARTITION_LIST_ITEM" maxOccurs="unbounded">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="NAME" type="ku:char30ElementWithValue1"/>
      <xsd:element name="VALUES" type="ku:char4000ElementWithValue1" minOccurs="0"/>
      <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1" minOccurs="0"/>
      <xsd:element name="COMPRESS" type="ku:TableCompressTypeWithValue1" minOccurs="0"/>
      
      <xsd:element name="COLUMN_PROPERTIES" type="ku:COLUMN_PROPERTIESType" minOccurs="0"/>
     </xsd:sequence>
     <xsd:attribute name="src" type="ku:srcType"/>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="HASH_PARTITIONINGType">
  <xsd:sequence>
   <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType"/>
   <xsd:element name="DEFAULT_PHYSICAL_PROPERTIES" type="ku:DEFAULT_PHYSICAL_PROPERTIESType" minOccurs="0"/>
   <xsd:choice>
    <xsd:element name="PARTITIONS_BY_QUANTITY" type="ku:partitionByQuantityType"/>
    <xsd:element name="PARTITION_LIST" type="ku:partitionListType"/>
   </xsd:choice>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="partitionByQuantityType">
  <xsd:sequence>
   <xsd:element name="QUANTITY" type="ku:intElementWithValue1"/>
   <xsd:element name="TABLESPACE_LIST" type="ku:TablespaceListType" minOccurs="0"/>
   <xsd:element name="OVERFLOW_TABLESPACE_LIST" type="ku:TablespaceListType" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="TablespaceListType">
  <xsd:sequence>
   <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1" maxOccurs="unbounded"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="partitionListType">
  <xsd:sequence>
   <xsd:element name="PARTITION_LIST_ITEM" type="ku:TableHashPartitionClauseType" maxOccurs="unbounded"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="TableHashPartitionClauseType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="SEGMENT_ATTRIBUTES" type="ku:HashPartitionSEGMENT_ATTRIBUTESType" minOccurs="0"/>
   
   <xsd:element name="COLUMN_PROPERTIES" type="ku:COLUMN_PROPERTIESType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="HashPartitionSEGMENT_ATTRIBUTESType">
  <xsd:sequence>
   <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="OVERFLOW" minOccurs="0">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="LIST_PARTITIONINGType">
  <xsd:sequence>
   <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType"/>
   <xsd:element name="DEFAULT_PHYSICAL_PROPERTIES" type="ku:DEFAULT_PHYSICAL_PROPERTIESType" minOccurs="0"/>
   
   <xsd:choice minOccurs="0">
    <xsd:element name="HASH_SUBPARTITIONING" type="ku:SUBPARTITIONINGType"/>
    <xsd:element name="LIST_SUBPARTITIONING" type="ku:SUBPARTITIONINGType"/>
    <xsd:element name="RANGE_SUBPARTITIONING" type="ku:SUBPARTITIONINGType"/>
   </xsd:choice>
   <xsd:element name="PARTITION_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="PARTITION_LIST_ITEM" type="ku:TableRangeListPartitionClauseType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="REFERENCE_PARTITIONINGType">
  <xsd:sequence>
   <xsd:element name="CONSTRAINT" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="DEFAULT_PHYSICAL_PROPERTIES" type="ku:DEFAULT_PHYSICAL_PROPERTIESType" minOccurs="0"/>
   <xsd:element name="PARTITION_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="PARTITION_LIST_ITEM" type="ku:ReferencePartitionListItemType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="ReferencePartitionListItemType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:element name="PHYSICAL_PROPERTIES" type="ku:DEFAULT_PHYSICAL_PROPERTIESType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="SYSTEM_PARTITIONINGType">
  <xsd:sequence>
   <xsd:element name="DEFAULT_PHYSICAL_PROPERTIES" type="ku:DEFAULT_PHYSICAL_PROPERTIESType" minOccurs="0"/>
   <xsd:element name="PARTITION_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="PARTITION_LIST_ITEM" type="ku:ReferencePartitionListItemType" maxOccurs="unbounded"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="SUBPARTITIONINGType">
  <xsd:sequence>
   <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType"/>
   <xsd:choice>
    <xsd:element name="SUBPARTITION_COUNT" type="ku:int32766ElementWithValue1" minOccurs="0"/>
    <xsd:element name="SUBPARTITION_TEMPLATE" minOccurs="0">
     <xsd:complexType>
      <xsd:sequence>
       <xsd:element name="SUBPARTITION_LIST" type="ku:SUBPARTITION_LISTType"/>
      </xsd:sequence>
     </xsd:complexType>
    </xsd:element>
   </xsd:choice>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="ObjectTableClause">
  <xsd:sequence>
   <xsd:element name="OF_TYPE" type="ku:optSCHEMA_NAMEType"/>
   <xsd:element name="SUBSTITUTABLE" type="ku:YNElementWithValue1" minOccurs="0"/>
   <xsd:element name="OBJECT_COLUMN_PROPERTIES" type="ku:ObjectColumnPropertiesType" minOccurs="0"/>
   <xsd:group ref="ku:TableConstraintsGroup"/>
   <xsd:element name="ON_COMMIT" type="ku:ON_COMMITTypeWithValue1" minOccurs="0"/>
   <xsd:element name="OID" type="ku:OIDTypeWithValue1" minOccurs="0"/>
   <xsd:element name="OIDINDEX" type="ku:OIDINDEXType" minOccurs="0"/>
   <xsd:element name="PHYSICAL_PROPERTIES" type="ku:PhysicalPropertiesType" minOccurs="0"/>
   <xsd:element name="TABLE_PROPERTIES" type="ku:TablePropertiesType" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="XMLTypeTableClause">
  <xsd:sequence>
   <xsd:element name="OF_TYPE" type="ku:optSCHEMA_NAMEType"/>
   <xsd:element name="COL_LIST" minOccurs="0">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="COL_LIST_ITEM" type="ku:TableCOL_LIST_ITEMType" maxOccurs="1000"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
   <xsd:element name="OBJECT_COLUMN_PROPERTIES" type="ku:ObjectColumnPropertiesType" minOccurs="0"/>
   <xsd:group ref="ku:TableConstraintsGroup"/>
   <xsd:group ref="ku:XMLTypeColProperties1" minOccurs="0"/>
   <xsd:element name="ON_COMMIT" type="ku:ON_COMMITTypeWithValue1" minOccurs="0"/>
   <xsd:element name="OID" type="ku:OIDTypeWithValue1" minOccurs="0"/>
   <xsd:element name="OIDINDEX" type="ku:OIDINDEXType" minOccurs="0"/>
   <xsd:element name="PHYSICAL_PROPERTIES" type="ku:PhysicalPropertiesType" minOccurs="0"/>
   <xsd:element name="TABLE_PROPERTIES" type="ku:TablePropertiesType" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="ObjectColumnPropertiesType">
  <xsd:sequence>
   <xsd:element name="COL_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="COL_LIST_ITEM" type="ku:ObjTableColumnDefaultType" maxOccurs="1000"/>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="ObjTableColumnDefaultType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char4000ElementWithValue1"/>
   <xsd:element name="DEFAULT" type="ku:char4000ElementWithValue1" minOccurs="0"/>
   <xsd:element name="DATATYPE" type="ku:TypeNameElementWithValue1" minOccurs="0"/>
   <xsd:element name="LENGTH" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="CHAR_SEMANTICS" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="PRECISION" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="SCALE" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="NOT_NULL" type="ku:NOT_NULLType" minOccurs="0"/>
   <xsd:element name="SEGCOL_NUM" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="INTCOL_NUM" type="ku:intElementWithValue1" minOccurs="0"/>
   <xsd:element name="INTERNAL_NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 <xsd:complexType name="OIDINDEXType">
  <xsd:sequence>
   <xsd:element name="NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
   <xsd:group ref="ku:PhysicalAttributesClause"/>
   <xsd:element name="TABLESPACE" type="ku:char30ElementWithValue1" minOccurs="0"/>
  </xsd:sequence>
  
 </xsd:complexType>
 <xsd:complexType name="XMLTYPE_VIRTUAL_COLUMNSType">
  <xsd:sequence>
   <xsd:element name="COL_LIST">
    <xsd:complexType>
     <xsd:sequence>
      <xsd:element name="COL_LIST_ITEM" maxOccurs="1000">
       <xsd:complexType>
        <xsd:sequence>
         <xsd:element name="NAME" type="ku:char30ElementWithValue1" minOccurs="0"/>
         <xsd:element name="VIRTUAL" type="ku:char4000ElementWithValue1" minOccurs="0"/>
         <xsd:element name="CUSTOMER_AREA" minOccurs="0"/>
        </xsd:sequence>
       </xsd:complexType>
      </xsd:element>
     </xsd:sequence>
    </xsd:complexType>
   </xsd:element>
  </xsd:sequence>
  <xsd:attribute name="src" type="ku:srcType"/>
  
 </xsd:complexType>
 
 <xsd:simpleType name="LobretentionType">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="AUTO"/>
   <xsd:enumeration value="MIN"/>
   <xsd:enumeration value="MAX"/>
   <xsd:enumeration value="NONE"/>
   <xsd:enumeration value="Y"/>
   <xsd:enumeration value="N"/>
   <xsd:enumeration value=""/>
  </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="LobretentionTypeWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:LobretentionType">
    <xsd:attribute name="value1" type="ku:LobretentionType"/>
    <xsd:attribute name="src" type="ku:srcType"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
</xsd:schema>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de