Edit D:\app\Administrator\product\11.2.0\dbhome

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

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

NAME
    kusmvt.xsd
DESCRIPTION
    XML Schema types for MATERIALIZED_VIEW SXML.

MODIFIED        MM/DD/YY
    lbarton    06/03/08 - bug 6120168: parsed queries
    lbarton    01/03/08 - bug 6720629: column aliases
    lbarton    12/19/07 - Bug 6655531: customer area
    lbarton    11/15/06 - diff support
    htseng     09/29/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="kustablt.xsd"/>
 <xsd:complexType name="MATERIALIZED_VIEWType">
  <xsd:sequence>
   <xsd:group ref="ku:SCHEMA_NAMEGroup"/>
   <xsd:element name="COL_LIST" type="ku:SimpleCOL_LISTType" minOccurs="0"/>
   <xsd:element name="OF_TYPE" type="ku:OFSchemaNameType" minOccurs="0"/>
   
   <xsd:element name="SCOPE_CONSTRAINT_LIST" type="ku:SCOPE_CONSTRAINT_LISTType" minOccurs="0"/>
   <xsd:choice>
    <xsd:element name="ON_PREBUILT_TABLE" type="ku:PreBuiltTableType"/>
    <xsd:group ref="ku:MViewPropertiesGroup"/>
   </xsd:choice>
   <xsd:choice>
    <xsd:element name="USING_NO_INDEX" type="ku:EmptyType" minOccurs="0"/>
    <xsd:element name="INDEX_ATTRIBUTES" type="ku:INDEX_ATTRIBUTESType" minOccurs="0"/>
   </xsd:choice>
   <xsd:choice>
    <xsd:element name="NEVER_REFRESH" type="ku:EmptyType"/>
    <xsd:element name="REFRESH" type="ku:RefreshClause"/>
   </xsd:choice>
   <xsd:element name="FOR_UPDATE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="QUERY_REWRITE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:choice>
    <xsd:element name="SUBQUERY" type="ku:stringElementWithValue1"/>
    <xsd:element name="PARSED_SUBQUERY" type="ku:PrsQueryType"/>
   </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="OFSchemaNameType">
  <xsd:sequence>
   <xsd:group ref="ku:SCHEMA_NAMEGroup"/>
  </xsd:sequence>
 
 </xsd:complexType>
 
 <xsd:complexType name="PreBuiltTableType">
  <xsd:sequence>
   <xsd:element name="REDUCED_PRECISION" type="ku:YNElementWithValue1"/>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:group name="MViewPropertiesGroup">
  <xsd:sequence>
   <xsd:element name="PHYSICAL_PROPERTIES" type="ku:PhysicalPropertiesType"/>
   <xsd:element name="COLUMN_PROPERTIES" type="ku:COLUMN_PROPERTIESType" minOccurs="0"/>
   <xsd:choice id="TablePartitioning" minOccurs="0">
    <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:choice>
   <xsd:element name="CACHE" type="ku:EmptyType" minOccurs="0"/>
   <xsd:choice>
    <xsd:element name="PARALLEL" type="ku:PARALLELTypeWithValue1" minOccurs="0"/>
    <xsd:element name="PARALLEL_DEGREE" type="ku:OldPARALLELType" minOccurs="0"/>
   </xsd:choice>
   <xsd:element name="BUILD" type="ku:BuildTypeNameWithValue1" minOccurs="0"/>
  </xsd:sequence>
 
 </xsd:group>
 
 <xsd:simpleType name="BuildTypeName">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="IMMEDIATE"/>
   <xsd:enumeration value="DEFERRED"/>
  </xsd:restriction>
 
 </xsd:simpleType>
 <xsd:complexType name="BuildTypeNameWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:BuildTypeName">
    <xsd:attribute name="value1" type="ku:BuildTypeName"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
 <xsd:complexType name="RefreshClause">
  <xsd:sequence>
   <xsd:choice>
    <xsd:element name="FAST" type="ku:EmptyType" minOccurs="0"/>
    <xsd:element name="COMPLETE" type="ku:EmptyType" minOccurs="0"/>
   </xsd:choice>
   <xsd:element name="ON_COMMIT" type="ku:EmptyType" minOccurs="0"/>
   <xsd:element name="START_WITH" type="ku:char128ElementWithValue1" minOccurs="0"/>
   <xsd:element name="NEXT" type="ku:char128ElementWithValue1" minOccurs="0"/>
   <xsd:choice>
    <xsd:element name="WITH_PRIMARY_KEY" type="ku:EmptyType" minOccurs="0"/>
    <xsd:element name="WITH_ROWID" type="ku:EmptyType" minOccurs="0"/>
   </xsd:choice>
   <xsd:element name="MASTER_ROLLBACK_SEGMENT" type="ku:RollBackSegClause" minOccurs="0"/>
   <xsd:element name="LOCAL_ROLLBACK_SEGMENT" type="ku:RollBackSegClause" minOccurs="0"/>
   <xsd:element name="CONSTRAINTS" type="ku:RefreshConstraintWithValue1" minOccurs="0"/>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:complexType name="RollBackSegClause">
  <xsd:sequence>
   <xsd:choice>
    <xsd:element name="NAME" type="ku:char4000ElementWithValue1" minOccurs="0"/>
    <xsd:element name="DEFAULT" type="ku:EmptyType" minOccurs="0"/>
   </xsd:choice>
  </xsd:sequence>
 
 </xsd:complexType>
 <xsd:simpleType name="RefreshConstraint">
  <xsd:restriction base="xsd:string">
   <xsd:enumeration value="TRUSTED"/>
   <xsd:enumeration value="ENFORCED"/>
  </xsd:restriction>
 
 </xsd:simpleType>
 <xsd:complexType name="RefreshConstraintWithValue1">
  <xsd:simpleContent>
   <xsd:extension base="ku:RefreshConstraint">
    <xsd:attribute name="value1" type="ku:RefreshConstraint"/>
   </xsd:extension>
  </xsd:simpleContent>
 </xsd:complexType>
</xsd:schema>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de