To migrate XML data stored in VARCHAR or CLOB columns to equivalent schemas with XML type columns, do the following:
- Verify the XML data is well-formed and conforms to rules of XML formatting.
- Create new versions of the tables using XML type for columns that will hold the XML data.
- Insert the XML text into the XML columns using the NEW XML operator or the CREATEXML function.