dbchangelog-ext.xsd schema is missing definition for MaterializedViewRefreshType

[JaroKuruc]

MaterializedViewRefreshType simple type referenced in refreshMaterializedView element definition for refreshType attribute (line 205) is not defined in the schema anywhere. This renders the whole schema invalid.

src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'simpleType definition' component.
src-resolve: Cannot resolve the name 'MaterializedViewRefreshType' to a(n) 'type definition' component.

┆Issue is synchronized with this Jira Bug by Unito

[gitfool]

I'm no expert, but according to DBMS_MVIEW.REFRESH it looks like the xsd should be updated to contain something like:

<xsd:simpleType name="MaterializedViewRefreshType">
    <xsd:restriction base="xsd:string">
        <xsd:enumeration value="always"></xsd:enumeration>
        <xsd:enumeration value="complete"></xsd:enumeration>
        <xsd:enumeration value="fast"></xsd:enumeration>
        <xsd:enumeration value="force"></xsd:enumeration>
        <xsd:enumeration value="partitions"></xsd:enumeration>
    </xsd:restriction>
</xsd:simpleType>

This will require more than an xsd schema change though - the values expected can be found at RefreshMaterializedViewOracle.java#L42; most of the above are missing and the second complete should be force.

(I'd submit a PR, but I haven't programmed in Java for a couple of decades.)