Correcting XML data after running CHECK DATA
After you run the CHECK DATA utility, you might need to correct XML data.
Procedure
To correct XML data after running CHECK DATA:
Based on the CHECK DATA output, perform one of the following actions:
Problem | Action |
---|---|
Problem with corrupted XML data | REPAIR statements are generated to delete each corrupted XML document from the XML table space and its associated node ID index entry. |
Problem with document ID index | Run generated REPAIR LOCATE TABLESPACE control statements. |
Problem with node ID index | Run generated REPAIR LOCATE TABLESPACE control statements. |
Problem with integrity of XML column in the base table and the node ID index |