Correcting XML data after running CHECK INDEX
After you run the CHECK INDEX utility, you might need to correct XML data.
Procedure
To correct XML data:
Based on the CHECK INDEX output, perform one of the following
actions:
Problem | Action |
---|---|
Problem with a document ID index |
|
Problem with an XML table space for a node ID index or an XML index and the index is correct | Run REPAIR LOCATE RID DELETE to remove the orphan row. |
Problem with an XML table space for a node ID index or an XML index and the index is incorrect | Run REBUILD INDEX or RECOVER INDEX to rebuild the index. |
Problem with an XML index over an XML table space | Run REBUILD INDEX to rebuild the index. Restriction: Do not run REPAIR LOCATE RID DELETE to remove orphan
rows unless the node ID index does not represent the same row and
the base table space does not use the document ID index.
|