Effective with Release 11.2, the SYS.XMLTABLEINDEX index type is deprecated, and therefore the Spatial WFS and CSW createXMLTableIndex methods create indexes of type XDB.XMLINDEX instead of type SYS.XMLTABLEINDEX as in previous releases. However, if you have data from a previous release that was indexed using one or more SYS.XMLTABLEINDEX indexes, you must drop the associated indexes before the upgrade and re-create the indexes after the upgrade, as follows:
Using Oracle Database Release 11.1, call the dropXMLTableIndex method (in oracle.spatial.csw.CSWAdmin or oracle.spatial.wfs.WFSAdmin, as appropriate depending on the application) to drop associated indexes.
Upgrade the database from Release 11.1 to Release 11.2.
Using Oracle Database Release 11.2, call the createXMLTableIndex (in oracle.spatial.csw.CSWAdmin or oracle.spatial.wfs.WFSAdmin, as appropriate depending on the application) to create indexes that were dropped in step 1.
For information about Spatial and Graph Web Feature Service (WFS) support, see Web Feature Service (WFS) Support, and especially the following:
createXMLTableIndex method (createXMLTableIndex method)
dropXMLTableIndex method (dropXMLTableIndex method)
getIsXMLTableIndexCreated method (getIsXMLTableIndexCreated method)
genXMLIndex and idxPaths parameters of the publishFeatureType method (publishFeatureType method)
setXMLTableIndexInfo method (setXMLTableIndexInfo method)
For information about Spatial and Graph Catalog Services for the Web (CSW) support, see Catalog Services for the Web (CSW) Support, and especially the following:
createXMLTableIndex method (createXMLTableIndex method)
dropXMLTableIndex method (dropXMLTableIndex method)
getIsXMLTableIndexCreated method (getIsXMLTableIndexCreated method)
genXMLIndex and idxPaths parameters of the publishRecordType method (publishRecordType method)
setXMLTableIndexInfo method (setXMLTableIndexInfo method)