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

Edit D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\xml\xsl\knfcf1.xsl

<?xml version="1.0" ?>
<!-- 
NAME
    knfcf1.xsl - replication Flavor Column Filtering script #1

DESCRIPTION
    XSLT stylesheet for filtering out columns that aren't in
    a given list from a table or index.
    FILTER_COLUMNS contains the list of columns to include.
    Any columns not in FILTER_COLUMNS will be removed.
    Any constraints containing one or more columns not in FILTER_COLUMNS
      will be removed. This xsl script tags constraints with columns
      not in FILTER_COLUMNS with DELETE_FLAVOR_COLUMNS. replfcf2.xsl
      must then be called to remove the constraints.

NOTES
    Do NOT modify this file under any circumstance. If you wish to use this
    stylesheet with an external XML/XSL parser, first make a copy then reverse
    the comments on any xsl:import statements appearing below.

MODIFIED	MM/DD/YY
    elu         05/01/01 - add support for partitions
    gclaborn    11/06/00 - Add no modify comment; change name
    elu 	08/14/00 - Created.
 -->

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:param name="FILTER_COLUMNS"/>
<xsl:param name="FILTER_NT_STORE"/>

<xsl:template match="@*|node()">
 <xsl:copy>
  <xsl:apply-templates select="@*|node()"/>
 </xsl:copy>
</xsl:template>

<xsl:template match="INDEX_T/COL_LIST/COL_LIST_ITEM
                [not(contains($FILTER_COLUMNS,concat(',',COL/COL_NUM,',')))]"/>

<xsl:template match="TABLE_T/COL_LIST/COL_LIST_ITEM
                    [not(contains($FILTER_COLUMNS,concat(',',COL_NUM,',')))]"/>

<xsl:template match="TABLE_T/PKREF_LIST/PKREF_LIST_ITEM
                    [not(contains($FILTER_COLUMNS,concat(',',COL_NUM,',')))]"/>

<xsl:template match="NTS_ITEM
                  [not(contains($FILTER_NT_STORE,concat(',',NTAB_NUM,',')))]"/>

<xsl:template 
       match="TABLE_T/PART_OBJ/PARTCOLS/PARTCOLS_ITEM/COL">
  <xsl:copy>
  <xsl:if test = "not(contains($FILTER_COLUMNS, concat(',', COL_NUM, ',')))">
   <DELETE_FLAVOR_COLUMN/>
  </xsl:if>
  <xsl:apply-templates select="@*|node()"/>
 </xsl:copy>
</xsl:template>

<xsl:template 
       match="TABLE_T/PART_OBJ/SUBPARTCOLS/SUBPARTCOLS_ITEM/COL">
  <xsl:copy>
  <xsl:if test = "not(contains($FILTER_COLUMNS, concat(',', COL_NUM, ',')))">
   <DELETE_FLAVOR_COLUMN/>
  </xsl:if>
  <xsl:apply-templates select="@*|node()"/>
 </xsl:copy>
</xsl:template>

<xsl:template 
       match="TABLE_T/CON1_LIST/CON1_LIST_ITEM/IND/COL_LIST/COL_LIST_ITEM/COL">
  <xsl:copy>
  <xsl:if test = "not(contains($FILTER_COLUMNS, concat(',', COL_NUM, ',')))">
   <DELETE_FLAVOR_COLUMN/>
  </xsl:if>
  <xsl:apply-templates select="@*|node()"/>
 </xsl:copy>
</xsl:template>

<xsl:template 
           match="TABLE_T/CON1_LIST/CON1_LIST_ITEM/COL_LIST/COL_LIST_ITEM/COL">
  <xsl:copy>
  <xsl:if test = "not(contains($FILTER_COLUMNS, concat(',', COL_NUM, ',')))">
   <DELETE_FLAVOR_COLUMN/>
  </xsl:if>
  <xsl:apply-templates select="@*|node()"/>
 </xsl:copy>
</xsl:template>

<xsl:template 
   match="TABLE_T/CON2_LIST/CON2_LIST_ITEM/SRC_COL_LIST/SRC_COL_LIST_ITEM/COL">
  <xsl:copy>
  <xsl:if test = "not(contains($FILTER_COLUMNS, concat(',', COL_NUM, ',')))">
   <DELETE_FLAVOR_COLUMN/>
  </xsl:if>
  <xsl:apply-templates select="@*|node()"/>
 </xsl:copy>
</xsl:template>

</xsl:stylesheet>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de